Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Reserved Words

Reserved Words (Abbreviated List**)
A
ABSOLUTE*
ACTION*
ADD*
ADMINDB*
ALL*
ALLOCATE*
Alphanumeric*
ALTER*
AND*
ANY*
Application
ARE*
AS*
ASC*
ASSERTION*
Assitant
AT*
AUTHORIZATION*
AUTOINCREMENT*
Avg*
AUTHORIZATION
B
BACKUP
BAND*
BEGIN*
BETWEEN*
BINARY*
BIT*
BIT_LENGTH*
BNOT*
BOR*
BOTH*
BREAK
BROWSE
BULK
BXOR*
BY*
BYTE*
C
CASCADE*
CASCADED*
CASE*
CAST*
CATALOG*
CHAR*
CHAR_LENGTH*
CHARACTER*
CHARACTER_LENGTH*
CHECK*
CHECKPOINT
CLOSE*
CLUSTERED
COALESCE*
COLLATE*
COLLATION*
COLUMN*
COMMIT*
COMP*
CompactDatabase
COMPRESSION*
COMPUTE
CONNECT*
CONNECTION*
CONSTRAINT*
CONSTRAINTS*
CONTAINS
Container*
CONTAINSTABLE
CONTINUE*
CONVERT*
CORRESPONDING*
Count*
COUNTER*
CREATE*
CREATEDB*
CreateDatabase
CreateField
CreateGroup
CreateIndex
CreateObject
CreateProperty
CreateRelation
CreateTableDef
CreateUser
CreateWorkspace
CROSS*
CURRENCY*
CURRENT*
CURRENT_DATE*
CURRENT_TIME*
CURRENT_TIMESTAMP*
CURRENT_USER*
CurrentUser
CURSOR*
D
DATABASE*
DATE*
DATETIME*
DAY*
DBCC
DEALLOCATE*
DEC*
DECIMAL*
DECLARE*
DEFAULT*
DEFERRABLE*
DEFERRED*
DELETE*
DENY
DESC*
DESCRIBE*
Description
DESCRIPTOR*
DIAGNOSTICS*
DISALLOW*
DISCONNECT*
DISK
DISTINCT*
DISTINCTROW
DISTRIBUTED
Document
DOMAIN*
DOUBLE*
DROP*
DUMP
E
Echo
ELSE*
END*
END-EXEC*
Eqv
ERRLVL
Error
ESCAPE*
EXCEPT*
EXCEPTION*
EXEC*
EXECUTE*
EXCLUSIVECONNECT*
EXISTS*
EXIT
EXTERNAL*
EXTRACT*
F
FALSE*
FETCH*
Field, Fields
FILE
FillCache
FILLFACTOR
FIRST*
FLOAT*
FLOAT4*
FLOAT8*
FOR*
FOREIGN*
Form, Forms
FOUND*
FREETEXT
FREETEXTTABLE
FROM*
FULL*
FUNCTION
G
GENERAL*
GET*
GetObject
GetOption
GLOBAL*
GO*
GOTO*
GotoPage
GRANT*
GROUP*
GROUPBY
GUID*
H
HAVING*
HOLDLOCK
HOUR*
I
IDENTITY*
IDENTITY_INSERT
IDENTITYCOL
Idle
IEEEDOUBLE*
IEEESINGLE*
IF
IGNORE*
IMAGE*
IMMEDIATE*
Imp
IN
Index
Indexes
INDICATOR*
INHERITABLE*
ININDEX*
INITIALLY*
INNER*
INPUT*
INSENSITIVE*
INSERT*
InsertText
INT*
INTEGER*
INTEGER1*
INTEGER2*
INTEGER4*
INTERSECT*
INTERVAL*
INTO*
IS*
ISOLATION*
J
JOIN*
K
KEY*
KILL
L
LANGUAGE*
LAST*
LastModified
LEADING*
LEFT*
Level*
LIKE*
LINENO
LOAD
LOCAL*
LOG
LOGICAL*
LOGICAL1*
LONG*
LONGBINARY*
LONGCHAR*
LONGTEXT*
LOWER*
M
Macro
Match*
Max*
Min*
MINUTE*
Mod
MODULE*
MONTH*
MEMO*
MERGE
Module*
MONEY*
Move
N
NAME
NAMES*
NATIONAL*
NATURAL*
NCHAR*
NewPassword
NEXT*
NO*
NOCHECK
NONCLUSTERED
NOT*
Note*
NULL*
NULLIF*
NUMBER*
NUMERIC*
O
Object*
OCTET_LENGTH*
OF
OFF
OFFSET
OFFSETS
OFOLEOBJECT*
OLEOBJECT
ON
ONONLY*
OPEN*
OpenRecordset
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
OPTION*
OR
ORDER
Orientation
ORORDER*
OUTER*
OUTPUT*
OVER
OVERLAPS*
OWNERACCESS*
P
PAD*
Parameter
PARAMETERS*
Partial*
PASSWORD*
PERCENT*
PIVOT*
PLAN
POSITION*
PRECISION*
PREPARE*
PRESERVE*
PRIMARY*
PRINT
PRIOR*
PRIVILEGES*
PROC*
PROCEDURE*
Property
PUBLIC*
Q
Queries
Query
Quit
R
RAISERROR
READ*
READPAST
READTEXT
REAL*
Recalc
RECONFIGURE
Recordset
REFERENCES*
Refresh
RefreshLink
RegisterDatabase
Relation
RELATIVE*
Repaint
RepairDatabase
REPLICATION
Report
Reports
Requery
RESTORE
RESTRICT*
RETURN
REVERT
REVOKE*
RIGHT*
ROLLBACK*
ROWCOUNT
ROWGUIDCOL
ROWS*
RULE
S
SAVE
SCHEMA*
SCREEN
SCROLL*
SECOND*
SECTION*
SECURITYAUDIT
SELECT*
SELECTSCHEMA*
SELECTSECURITY*
SESSION*
SESSION_USER*
SET*
SetFocus
SetOption
SETUSER
SHORT*
SHUTDOWN
SINGLE*
SIZE*
SMALLINT*
SOME*
SPACE*
SQL*
SQLCODE*
SQLERROR*
SQLSTATE*
STATISTICS
StDev
StDevP
STRING*
SUBSTRING*
Sum*
SYSTEM_USER*
T
TABLE*
TableDef
TableDefs
TableID*
TABLESAMPLE
TEMPORARY*
TEXT*
TEXTSIZE
THEN*
TIME*
TIMESTAMP*
TIMEZONE_HOUR*
TO*
TOP*
TRAILING*
TRAN
TRANSACTION*
TRANSFORM*
TRANSLATE*
TRANSLATION*
TRIGGER
TRIM*
TRUE*
TRUNCATE
TSEQUAL
Type
U
UNION*
UNIQUE*
UNIQUEIDENTIFIER*
UNKNOWN*
UNPIVOT
UPDATE*
UPDATEIDENTITY*
UPDATEOWNER*
UPDATESECURITY*
UPDATETEXT
UPPER*
USE
USAGE*
USER*
USING*
V
VALUE*
VALUES*
Var, VarP
VARBINARY*
VARCHAR*
VARYING*
VIEW*
W
WAITFOR
WHEN*
WHENEVER*
WHERE*
WHILE
WITH*
WORK*
Workspace
WRITE*
WRITETEXT
X
Xor
Y
Year*
YES
YESNO*
Z
ZONE*
 
 
Legend
BLUE – SQL Server 2008 R2
MAROON – Microsoft Access
BLACK – Microsoft Access & SQL Server 2008 R2
* – Microsoft Access Database Engine

**For a complete list of Reserved Words see… Problem Names and Reserved Words in Microsoft Access by Allen Browne

862 total views, 1 views today