Change name of all fields in all tables that have a - in them... Query to do this?

  • Thread starter Thread starter Davisro
  • Start date Start date
D

Davisro

I have a database someone created table names have a "-" and
field names have "-" in them. There are about 8 tables and 8 forms but each
table has ~ 100 - 125 fields. I don't want to change them by hand is there
a way to do this via system tables or other way automatically?


Thanks,

Rog
 
Davisro said:
I have a database someone created table names have a "-" and
field names have "-" in them. There are about 8 tables and 8 forms but each
table has ~ 100 - 125 fields. I don't want to change them by hand is there
a way to do this via system tables or other way automatically?
Click to expand...

That'a lot of fields per table.

See the Scan and replace utilities section at the Microsoft Access
third party utilities, products, tools, modules, etc. page at my
website.
http://www.granite.ab.ca/access/thirdparty.htm

You have to use these utilities as there is nothing which will go
through all the forms and VBA code.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top