access保留字变量名列表
access保留字&变量名列表，建表时应避免使用这些词汇和符号。
access 2002/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
group by
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
以及以下标点符号
.
/
*
:
!
#
&
-
?
'
$
access 2000
-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
group by
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/