Access保留字&变量名列表，建表时应避免使用这些词汇和符号。

Access2002/2003

-复制代码 代码如下:

A

ADD

ALL

Alphanumeric

ALTER

AND

ANY

Application

AS

ASC

Assistant

AUTOINCREMENT

Avg

-B

BETWEEN

BINARY

BIT

BOOLEAN

BY

BYTE

-C

CHAR,CHARACTER

COLUMN

CompactDatabase

CONSTRAINT

Container

Count

COUNTER

CREATE

CreateDatabase

CreateField

CreateGroup

CreateIndex

CreateObject

CreateProperty

CreateRelation

CreateTableDef

CreateUser

CreateWorkspace

CURRENCY

CurrentUser

-D

DATABASE

DATE

DATETIME

DELETE

DESC

Description

DISALLOW

DISTINCT

DISTINCTROW

Document

DOUBLE

DROP

-E

Echo

Else

End

Eqv

Error

EXISTS

Exit

-F

FALSE

Field,Fields

FillCache

FLOAT,FLOAT4,FLOAT8

FOREIGN

Form,Forms

FROM

Full

FUNCTION

-G

GENERAL

GetObject

GetOption

GotoPage

GROUP

GROUPBY

GUID

-H

HAVING

-I

Idle

IEEEDOUBLE,IEEESINGLE

If

IGNORE

Imp

IN

INDEX

Index,Indexes

INNER

INSERT

InsertText

INT,INTEGER,INTEGER1,INTEGER2,INTEGER4

INTO

IS

-J

JOIN

-K

KEY

-L

LastModified

LEFT

Level

Like

LOGICAL,LOGICAL1

LONG,LONGBINARY,LONGTEXT

-M

Macro

Match

Max,Min,Mod

MEMO

Module

MONEY

Move

-N

NAME

NewPassword

NO

Not

Note

NULL

NUMBER,NUMERIC

-O

Object

OLEOBJECT

OFF

ON

OpenRecordset

OPTION

OR

ORDER

Orientation

Outer

OWNERACCESS

-P

Parameter

PARAMETERS

Partial

PERCENT

PIVOT

PRIMARY

PROCEDURE

Property

-Q

Queries

Query

Quit

-R

REAL

Recalc

Recordset

REFERENCES

Refresh

RefreshLink

RegisterDatabase

Relation

Repaint

RepairDatabase

Report

Reports

Requery

RIGHT

-S

SCREEN

SECTION

SELECT

SET

SetFocus

SetOption

SHORT

SINGLE

SMALLINT

SOME

SQL

StDev,StDevP

STRING

Sum

-T

TABLE

TableDef,TableDefs

TableID

TEXT

TIME,TIMESTAMP

TOP

TRANSFORM

TRUE

Type

-U

UNION

UNIQUE

UPDATE

USER

-V

VALUE

VALUES

Var,VarP

VARBINARY,VARCHAR

-W

WHERE

WITH

Workspace

-X

Xor

-Y

Year

YES

YESNO

以及以下标点符号

.

/

*

:

!

#

&

-

?

"

'

$

Access2000

-A

ADD

ALL

Alphanumeric

ALTER

AND

ANY

Application

AS

ASC

Assistant

AUTOINCREMENT

Avg

-B

BETWEEN

BINARY

BIT

BOOLEAN

BY

BYTE

-C

CHAR,CHARACTER

COLUMN

CompactDatabase

CONSTRAINT

Container

Count

COUNTER

CREATE

CreateDatabase

CreateField

CreateGroup

CreateIndex

CreateObject

CreateProperty

CreateRelation

CreateTableDef

CreateUser

CreateWorkspace

CURRENCY

CurrentUser

-D

DATABASE

DATE

DATETIME

DELETE

DESC

Description

DISALLOW

DISTINCT

DISTINCTROW

Document

DOUBLE

DROP

-E

Echo

Else

End

Eqv

Error

EXISTS

Exit

-F

FALSE

Field,Fields

FillCache

FLOAT,FLOAT4,FLOAT8

FOREIGN

Form,Forms

FROM

Full

FUNCTION

-G

GENERAL

GetObject

GetOption

GotoPage

GROUP

GROUPBY

GUID

-H

HAVING

-I

Idle

IEEEDOUBLE,IEEESINGLE

If

IGNORE

Imp

IN

INDEX

Index,Indexes

INNER

INSERT

InsertText

INT,INTEGER,INTEGER1,INTEGER2,INTEGER4

INTO

IS

-J

JOIN

-K

KEY

-L

LastModified

LEFT

Level

Like

LOGICAL,LOGICAL1

LONG,LONGBINARY,LONGTEXT

-M

Macro

Match

Max,Min,Mod

MEMO

Module

MONEY

Move

-N

NAME

NewPassword

NO

Not

NULL

NUMBER,NUMERIC

-O

Object

OLEOBJECT

OFF

ON

OpenRecordset

OPTION

OR

ORDER

Orientation

Outer

OWNERACCESS

-P

Parameter

PARAMETERS

Partial

PERCENT

PIVOT

PRIMARY

PROCEDURE

Property

-Q

Queries

Query

Quit

-R

REAL

Recalc

Recordset

REFERENCES

Refresh

RefreshLink

RegisterDatabase

Relation

Repaint

RepairDatabase

Report

Reports

Requery

RIGHT

-S

SCREEN

SECTION

SELECT)

SET

SetFocus

SetOption

SHORT

SINGLE

SMALLINT

SOME

SQL

StDev,StDevP

STRING

Sum

-T

TABLE

TableDef,TableDefs

TableID

TEXT

TIME,TIMESTAMP

TOP

TRANSFORM

TRUE

Type

-U

UNION

UNIQUE

UPDATE

User

-V

VALUE

VALUES

Var,VarP

VARBINARY,VARCHAR

-W

WHERE

WITH

Workspace

-X

Xor

-Y

Year

YES

YESNO

以及以下标点符号

.

/

*

:

!

#

&

-

?

"

'

$

转载自：

http://support.microsoft.com/kb/286335/

http://support.microsoft.com/kb/209187/