新手来看：jet 4.0 的保留字
INFO: Microsoft Jet 4.0 Reserved Words
The information in this article applies to:
Microsoft access 2000
This article was previously published under Q248738
For a Microsoft access 2002 version of this article, see 321266.
SUMMARY
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 INFORMATION
Reserved Words
|
A ABSOLUTE ACTION ADD ADMINDB ALL ALLOCATE ALPHANUMERIC ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AUTOINCREMENT AVG B BAND BEGIN BETWEEN BINARY BIT BIT_LENGTH BNOT BOR BOTH BXOR BY BYTE C CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHAR_LENGTH CHARACTER_LENGTH CHECK CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT COMP COMPRESSION CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTAINER CONTINUE CONVERT CORRESPONDING COUNT COUNTER CREATE CREATEDB CROSS CURRENCY CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR D DATABASE DATE DATETIME DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISALLOW DISCONNECT DISTINCT DOMAIN DOUBLE DROP E ELSE END END-EXEC ESCAPE EXCEPT EXCEPTION EXCLUSIVECONNECT EXEC EXECUTE EXISTS EXTERNAL EXTRACT F FALSE FETCH FIRST FLOAT FLOAT4 FLOAT8 FOR FOREIGN FOUND FROM FULL G GENERAL GET GLOBAL GO GOTO GRANT GROUP GUID H HAVING HOUR I IDENTITY IEEEDOUBLE IEEESINGLE IGNORE IMAGE IMMEDIATE IN INDEX INDICATOR INHERITABLE INITIALLY INNER INPUT INSENSITIVE INSERT INT INTEGER INTEGER1 INTEGER2 INTEGER4 INTERSECT INTERVAL INTO IS ISOLATION J JOIN K KEY L LANGUAGE LAST LEADING LEFT LEVEL LIKE LOCAL LOGICAL LOGICAL1 LONG LONGBINARY LONGCHAR LONGTEXT LOWER M MATCH MAX MEMO MIN MINUTE MODULE MONEY MONTH N NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NOTE NULL NULLIF NUMBER NUMERIC O OBJECT OCTET_LENGTH OF OLEOBJECT ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS OWNERaccess P PAD PARAMETERS PARTIAL PASSWORD PERCENT PIVOT POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROC PROCEDURE PUBLIC Q
R
Y |
Starting with Microsoft Data access Components (MDAC) version 2.6, MDAC no longer contains the following Jet components:
Microsoft Jet
Microsoft Jet OLE DB Provider
ODBC Desktop Database Drivers
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
239114 ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download Center
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://www.microsoft.com/data/mdacwfp.htm
Last Reviewed: 4/22/2003
Keywords: kbinfo kbProgramming KB248738
(责任编辑：admin)
- ·用DAO或ADO正确访问Access 2000
- ·Access开发网络共享版技巧（多人同时操
- ·access中ADO与DAO格式的区别和写法【总
- ·access执行操作查询的几种方法对比
- ·Access中CurrentDb().Execute 和DoCmd.
- ·[源创技巧]在ACCESS中使用代码来自动创
- ·更新访问权限 (Jet) 数据库中的 40 多
- ·【实例】ADO代码计算余额法
- ·DAO实现的子窗体记录分页显示
- ·分别使用DAO和ADO连接外部数据库和Sql
- ·怎样判断一个表是否存在于数据库中? (D
- ·处理加了密码的MDB文件
- ·谈ADO访问不同数据库的差别
- ·DAO基础(4)
- ·DAO基础(3)
- ·DAO基础(2)
