Microsoft Office Tutorials and References
In Depth Information
You should ensure that any name you use does not duplicate a property name or any key-
word Access reserves for special purposes. In general, you can avoid property and keyword
name conflicts by using two-word field, control, and object names. For example, use
StudentName instead of Name, and use OrderDate instead of Date to avoid name conflicts.
All database developers avoid spaces in names, mainly because spaces are not allowed
in server database management systems (DBMSs), such as SQL Server, Oracle, and DB2. If
you are prototyping a Microsoft Access database that you’ll migrate to one of these server
DBMSs, or if future requirements might force a migration, you should restrict your Access
identifier names so that they conform to the rules common to them all. Figure A-23 shows
the identifier naming rules for Access, SQL Server, Oracle, and DB2.
Figure A-23
Identifier naming rules for common database management systems
Identifier naming rule
Access
SQL Server
Oracle
DB2
Maximum character length
64
30
30
30
Allowable characters
Letters, digits, space, and
special characters, except
for period (.), exclamation
point (!), accent grave (`),
and square brackets ([ ])
Letters, digits, dollar
sign ($), underscore (_),
number symbol (#), and
at symbol (@)
Letters, digits, dollar
sign ($), underscore (_),
and number symbol (#)
Letters, digits, at symbol
(@), dollar sign ($),
underscore (_), and
number symbol (#)
Special rules
No spaces; first character
must be a letter or at
symbol (@)
No spaces; first character
must be a letter; stored in
the database in uppercase
No spaces; first character
must be a letter, at
symbol (@), dollar sign
($), or number symbol
(#); stored in the
database in uppercase
Search JabSto ::




Custom Search