Most developers use naming conventions to assign consistent names to their objects. What you might not realize is that an Access object name must be 64 characters or less. Try to use 65 characters, and Access will return an error. There are a few other guidelines you must exercise when naming objects:

• An object name can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave (`), and brackets ([ ]).
• An object name can't begin with a leading space.
• An object name can't include control characters (ASCII values 0 through 31).
• An object name can't include a double quotation mark (") in table, view, or stored procedure names in a Microsoft Access project.

Access Index

Main Index