Share via

comments in Access SQL - possible?

Anonymous
2013-02-07T10:52:21+00:00

comments in Access SQL - possible     Access help is no help as MS normally avoids mentioning anything to do with MS design shortcommings

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2013-02-07T10:58:52+00:00

    Sadly, no. There is no way to insert comments into SQL statements in Access.

    I generally document the structure of a database, the SQL strings and the VBA code in a Word document, and add comments in that document.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-02-07T11:05:20+00:00

    a V strange omission on MS's part

    Thanks for your help

    0 comments
  2. Anonymous
    2017-06-13T20:05:15+00:00

    Also:

    NOTE: Confirmed with Access 2003, 201, 2016 don't know about earlier versions.

    For a query in an MDB you can right-click in the query designer (anywhere in the empty space where the tables are), select Properties from the context menu, and enter text in the Description property.

    You're limited to 256 characters, but it's better than nothing.

    0 comments
  3. Anonymous
    2017-06-13T21:41:29+00:00

    Yes - comments are limited, but it is one solution, the comments look like this:

    Regards,

    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    0 comments