ACC2000: Unsupported SQL Keywords Are Not Listed in Microsoft Access (209759)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209759
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SUMMARY

Microsoft Access documentation lists all SQL keywords that are supported in Microsoft Access but does not list SQL keywords that are not supported. This is so because there are over 200 ANSI SQL keywords that Microsoft Access does not support. Rather than list them all, Microsoft Access documentation lists only the supported keywords.

REFERENCES

For more information about what the reserved words are, click Microsoft Access Help on the Help menu, type Microsoft Jet Database Engine SQL Reserved Words in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbinfo kbusage KB209759
©2004 Microsoft Corporation. All rights reserved.