Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
List of Microsoft Jet 4.0 reserved words
Article ID: 321266 - View products that this article applies to.
This article was previously published under Q321266
For a Microsoft Access 2000 version of this article, see 248738
The Microsoft Jet database engine runs in several different modes depending on whether it is called from Microsoft Access, Data Access Objects, the Microsoft OLE DB Provider for Microsoft Jet, or the Microsoft Access ODBC driver. It can be run in either ANSI mode or non-ANSI (traditional) mode.
Each of these modes results in a slightly different set of reserved words. Queries written in one mode may use a reserved word as an identifier and fail in another mode because of this.
This article provides a list of reserved words to avoid when choosing identifier names.
The following is a list of reserved characters to avoid when choosing identifier names:
! Exclamation point
[ ] Brackets
` Grave Accent
Non-printable character (ex. a carriage return)
Starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no longer contains the following Jet components:
239114The MDAC 2.5 Stack and Windows File Protection white paper contains a full list of the components that are shipped with MDAC 2.5, along with a discussion of Windows File Protection. Refer to this white paper for more information about the Jet dynamic-link libraries (DLLs) that are included in MDAC 2.5, which are no longer a part of MDAC 2.6.
(http://support.microsoft.com/kb/239114/ )How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
For more information about MDAC 2.5 and Windows File Protection, see the following Microsoft Web site: