Table/field renames

[zkarj]

A while ago I inherited a database which I have been slowly improving through normalisation and adding of new data. Now I have it pretty close to what I want except for one thing.

A number of the tables (there are 18 in total) and many of the fields are inappropriately named. I would like to rename these to make more sense.

Can anyone suggest a good approach to this? I tried renaming a few tables thinking that only 'expressions' would need updating (according the the help). However, I discovered that 'expressions' includes anything in a Query apparently.

Now, I don't mind a lot of typing if necessary, but I am wary of Access dropping stuff or getting confused if I rename a table or field and then go through all the queries and reports and edit them.

TIA,
Allister.

 

[zkarj]

OK, I found a "Find and Replace" shareware plugin which has worked OK for the table names. It was a little tricky because it does not distinguish between different uses of the same names (table, field, caption, record source etc).

However it is going to be next to impossible to rename the fields with this unless they are already unique.

BTW, A2003 does NOT propagate field renames to queries.

There has to be a better way. I looked at Speed Ferret but it costs and it doesn't support A2003 anyway.

 

[zkarj]

Aye carumba!

Turned on. Lots of renames done now. But it did miss some stuff.