Microsoft Access does not restrict you from choosing object names that conflict with Jet, SQL Server, and ODBC reserved words. This can cause confusion in your code, and can cause potential problems if you upsize your database in the future.
Avoid using names for tables, table fields, queries, and query columns that conflict with reserved words by reviewing the following Reserved Words lists.
Although it is a minor issue, having object names that conflict with Jet reserved words may cause confusion when you reference the table, field, query, or column name.
Table, field, query, and column names that conflict with SQL Server reserved words may cause problems if you upsize your database to SQL Server.
Table, field, query, and column names that conflict with announced future SQL Server reserved words may cause problems if you upsize your database to a future version of SQL Server.
Names that conflict with ODBC reserved words may cause issues when allowing ODBC connections.
To avoid problems with upsizing this table to SQL Server in the future, donít use characters that are not allowed in SQL Server (including (', *, and ").
FMS's Total Access Analyzer performs detailed analysis of your Access database objects and detects these tips, as well as hundreds of others. Find out more!
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.