What does a reserved word mean?
Reserved words have a specific meaning to Access or to the Microsoft Jet database engine. If you use a reserved word or symbol, you may receive an error such as the following: The wizard was unable to preview your report, possibly because a table needed by your report is exclusively locked.
What if I use a reserved word in Access 2007?
If you use a reserved word, such as date, value, name, text, and year, in Access 2007, you may receive the following message: The Name you supplied is a reserved word. Reserved words have a specific meaning to Microsoft Office Access or to the Microsoft Office Access database engine.
What is a reserved sign?
A reserved sign is an efficient way to avoid an unrelated person entering the area that is not available for everyone. Moreover, the reserved sign should be crafted clearly so that it indicates the reserved area effectively. It reduces the chances of mess that may create when two people apply for the same table or room in the restaurant.
How can I avoid errors if a name contains reserved words?
For existing objects with names that contain reserved words, you can avoid errors by surrounding the object name with brackets ( [ ]). Because it is not practical to provide a list of all reserved words, such as built-in function names or Microsoft Access user-defined names, please check your product documentation for additional reserved words.