change table field names in multiple databases

[kuanli]

I have 30 databases, each having one table which are identical in design (They hold different data for different people). Now I need to change some field names for all tables in all databases. I wonder if there is a way to do it instead of typing the new names again and again.

Thanks in advance.

Kuan

 

[GrantDB]

You could try this
CurrentDb.TableDefs("tblName&quot.Fields("OldFieldName&quot.Name="NewFieldName"

However, you will have to take care that the old field name isn't used anywhere else. You could use a utility such as Speed Ferret from

http://www.moshannon.com/

or Find and Replace from

http://www.dnai.com/~rfisher/

- although I have used neither

Grant

 

[kuanli]

Thanks a lot! It worked!

Kuan

 

[kuanli]

I have all the field names in the tables changed, but now all the forms are screwed up. "#name" is everywhere. I figured out that I need to change the control source to match the new names. But there are way too many to change by hand. Please, please help! My boss wants this ASAP!

 

[GrantDB]

The problem here would be knowing which control matches which field. You could go through each control on the form and change the name. How did you change the form names i.e what was the old and new names?