|
When creating names for your database objects (tables,
queries, forms, etc.), use only alpha-numeric characters. If you use special
characters in your object names, such as $, !, @, # and &, it is more
difficult to work with that name when developing your application. Some special
characters can even be interpreted as delimiters or data type specifiers by the
database engine or development environment, generating unexpected results that
are difficult to troubleshoot.
For example, if you name a data field Invoice#, you have to
enclose the name in square brackets ([]) when using it in queries and in VB
code. Even in places where you don't need to include square brackets around the
object name, it takes longer to type in special characters, which slows down
your development efforts.
Avoiding the use of special characters will make your life
as a developer much easier.
|