Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
List of reserved words in Jet 4.0
Article ID: 248738 - View products that this article applies to.
This article was previously published under Q248738
For a Microsoft Access 2002 version of this article, see 321266
For a Microsoft Access 97 or earlier version of this article, see 109312
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.
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: