SSMA column name warnings

The SSMA for Access produced several warnings about column names in tables such as ...
A2SS0030: Column 'WO #' has a name that might cause problems for the Access application to function correctly against SQL Server.
What sorts of problems might there be if I don't change the names?
LVL 1
Declan_BasileITAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"ouldn't the program be context sensitive and know when the word/symbol is a field name or part of a field name and when it is meant to be used for its reserved purpose?"

No guarantee really ...

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

I've been using this daily for 14 years ... if ... you do want to make those changes ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
# is a special character ... used to define literal dates, et  #01-27-2007#

Avoid using special characters ....

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"What sorts of problems might there be if I don't change the names?"

At a minimum ... a lot of confusion.  At worst, a lot of errors.

Also ... words like Date, Time etc are reserved words and should not be used for object or field names.

mx
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What is SSMA ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Same issue with such characters as $, @, ! *, & ... do not use these.

mx
0
 
Declan_BasileITAuthor Commented:
I think it would take a relatively long amount of time to change everywhere that the field names are referenced in my Access programs for the field names that I change.  If a reserved word or special symbol is used in the name of a column, wouldn't the program be context sensitive and know when the word/symbol is a field name or part of a field name and when it is meant to be used for its reserved purpose?
0
 
mbizupCommented:
C101,

I posted the wrong link on this one.  Can you change this so that MX's last comment is marked as Accepted?

{http:#19535008}

Thanks...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.