ACC2002: Error with ANSI-92 Reserved Words When SQL Server Compatibility Syntax (ANSI 92) Is Enabled (287417)

RESOLUTION

To avoid the error message, use one of the following workarounds.

Workaround 1

View the query in Design view.
Place brackets ([]) around the ANSI-92 reserved words.
Save the query.

Workaround 2

When you design the tables in the database, be careful not to use ANSI-92 reserved words. If a table has a field already defined, consider changing the field name.

Workaround 3

Consider disabling the SQL Server Compatibility Syntax (ANSI 92) option for the database. To disable the option:

On the Tools menu, click Options.
Click the Tables/Queries tab.
Click to clear the check boxes under SQL Server Compatibility Syntax (ANSI 92).

MORE INFORMATION

The following is a list of ANSI 92 reserved words that are known to generate the error mentioned in the "Symptoms" section of this article.

ABSOLUTE	ALLOCATE	ARE
AT	AUTHOZATION	BIT_LENGTH
BOTH	CASCADED	CAST
CATALOG	CHAR_LENGTH	CHARACTER_LENGTH
CLOSE	COALESCE	COLLATE
COLLATION	CONNECTION	CONTINUE
CORRESPONDING	CROSS	CURRENT
CURRENT_DATE	CURRENT_TIME	CURRENT_TIMESTAMP
CURRENT_USER	CURSOR	DEALLOCATE
DECLARE	DEFERRABLE	DEFERRED
DESCRIBE	DESCRIPTOR	DIAGNOSTICS
DISCONNECT	DOMAIN	END
END-EXEC	ESCAPE	EXCEPT
EXCEPTION	EXTERNAL	EXTRACT
FETCH	FOUND	FULL
GET	GLOBAL	GO
GOTO	IMMEDIATE	INDICATOR
INITIALLY	INPUT	INSENSITIVE
INTERSECT	INTERVAL	ISOLATION
LANGUAGE	LEADING	LOCAL
LOWER	MATCH	MODULE
NAMES	NATURAL	NEXT
NULL	OCTET_LENGTH	OF
ONLY	OPEN	OVERLAPS
PARTIAL	POSITION	PREPARE
PRESERVE	PRIOR	READ
RELATIVE	RESTRICT	ROWS
SCROLL	SECTION	SESSION
SESSION_USER	SIZE	SQL
SQLCODE	SQLERROR	SQLSTATE
SUBSTRING	SYSTEM_USER	TEMPORARY
THEN	TIMEZONE_HOUR	TIMEZONE_MINUTE
TRAILING	TRANSACTION	TRANSLATE
TRANSLATION	UNIQUE	UNKNOWN
UPPER	USAGE	USING
WHEN	WHENEVER	WRITE
ZONE

Steps to Reproduce the Behavior

Start Microsoft Access, and then open the sample database Northwinds.mdb.

Create the following table:

   Table: Table1
   ----------------------------
   Field Name: ID
   Data Type: Autonumber
   Indexed: Yes (No Duplicates)

   Field Name: Language
   Data Type: Text

   Field Name: Location
   Date Type: Text

   Table Properties: Table1
   ------------------------
   PrimaryKey: ID

Save the new table as Table1, and then add one record to the table.
Close the Table1 table.
On the Tools menu, click Options.
Click the Tables/Queries tab.
Under SQL Server Compatibility Syntax (ANSI 92), click to select the This database check box.
Create a new query in Design view.
Close the Add Table dialog box without making any selection.
On the View menu, click SQL View.
In the SQL window, type the following SQL statement:
SELECT Language FROM Table1
Try to run the query.

Note that you receive the error message that is mentioned in the "Symptoms" section of this article.