Solved: Rename fields in Access table & queries

[tammyl]

Is it possible to rename a table or field in access and have this update systematically through the database without affecting links, relationships, etc.

I have a pre-existing database that is similar to a new contact database but want to rename the tables & fields so they are relevant to the data for the new database.

Any help appreciated.

Thanks
tammyl

[OBP]

Normal Fields would be possible with quite a bit of VBA Code to chnage the Tables, queries, forms and reports, but as soon as you change a Table name or a Key Field you are in real trouble with the Relationships. You will have to break them before re-naming and re-establish them after re-naming.
But if you have VBA in the Old database that will become completely screwed up by the name changes, so you will have to change all of those as well, even simple Switchboards will need their tables changing to new level names etc.
I would have thought it would be easier to supply the necessary Append Queries to use after importing the old Tables in to the New Database, or even use VBA SQL to put the old data in to the new tables.
As long as it is transparent to the user it should be OK.