Article ID: 321266 - Last Review: August 18, 2004 - Revision: 4.3 List of Microsoft Jet 4.0 reserved words
This article was previously published under Q321266 For a Microsoft Access 2000 version of this article, see 248738
(http://support.microsoft.com/kb/248738/EN-US/
)
.
On This PageSUMMARY
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. MORE INFORMATIONReserved WordsA. Perod ! Exclamation point [ ] Brackets ` Grave Accent Leading space(s) 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:
239114
(http://support.microsoft.com/kb/239114/
)
How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
The 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.
For more information about MDAC 2.5 and Windows File Protection, see the following Microsoft Web site: http://msdn.microsoft.com/en-us/library/ms810823.aspx
(http://msdn.microsoft.com/en-us/library/ms810823.aspx)
| Other Resources Other Support Sites
CommunityGet Help NowArticle Translations
|






Windows Live
Facebook
Twitter
Linkedin
Digg it
Yahoo
Delicious
StumbleUpon
Yammer
Reddit
Technorati
FriendFeed
Email
Back to the top
