[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1125
  • Last Modified:

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?
0
Declan_Basile
Asked:
Declan_Basile
  • 5
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
# is a special character ... used to define literal dates, et  #01-27-2007#

Avoid using special characters ....

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
What is SSMA ?

mx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Same issue with such characters as $, @, ! *, & ... do not use these.

mx
0
 
Declan_BasileAuthor 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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now