Changing field names in a table

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I'm upscaling an Access database to SQL, but have to
change a few table field names as I foolishly gave them
names that are reserved words in SQL.

Are changes to table names propogated through the rest of
the database objects?
eg, if I change a field name, are my forms going to throw
an error as the controls have not updated? Will any
macros referencing that field be updated?

TIA
Tim
 
Recent versions of Access have features that will propagate changes in some
areas, but they are not perfect, and will not find all references to the
fields. I use and can recommend a utility called 'Find and Replace'
(www.rickworld.com). Another popular utility which I have not personally
used but has been recommended by others is SpeedFerret (www.moshannon.com).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top