Reserved words in Microsoft Access 97
This article was previously published under Q109312
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
This article lists words and symbols that should be avoided in field,object, and variable names because they are "reserved words," words thathave a specific meaning to Microsoft Access or the Microsoft Jet databaseengine. If you use a reserved word or symbol, you may receive an errorsuch as the following:
The wizard was unable to preview your report, possibly because a table needed by your report is exclusively locked.
For existing objects with names that contain reserved words, you can avoiderrors by surrounding the object name with brackets.
These words are reserved in all versions except where noted otherwise.Because it is not practical to provide a list of all reserved words, suchas built-in function names or Microsoft Access user-defined names, pleasecheck your product documentation for additional reserved words. Notethat if you set a reference to a type library, an object library, or anActiveX control, that library's reserved words are also reserved wordsin your database. For example, if you add an ActiveX control to a form,a reference is set and the names of the objects, methods, andproperties of that control become reserved words in your database.
-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 (7.0, 97)-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 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
The following symbols should not be used as part of a field name:
. / * : ! # & -
For more information about reserved words, search the Help Index for"reserved words."
Article ID: 109312 - Last Review: 12/04/2015 09:53:46 - Revision: 3.1
Microsoft Access 97 Standard Edition
- kbnosurvey kbarchive kbinfo KB109312