Can I change field names in an existing mdb

[RobG, Brisbane Aust]

I have fallen into the trap when throwing together a database a few years ago
of not using appropriate naming conventions in what has now become a very
large and quite complex database. I now have legacy field names such as
[Category code], which has a space in the name, rather than the more
appropriate [Category_code]. I have many queries, forms, reports and macros
that have such inappropriate field names used.

It would be straight forward to change the field name in the tables (using
the Table Design) and in any modules (using a global search & replace), but
how can I change the field name in the mdb queries, forms, reports and
macros? To manually open each querie, form, report and macro individually
and make the change would be an absolute nightmare.

Is it possible to design a VB routine that opens up each query, form, report
and macro and makes / updates the required change according to a seperate
table of the old and new field names? How would this work in say Reports
where the offending field name appears not just in the report header, detail
and footer bands but also in as a sort index?

Thanks for your suggestions in advance.

 

[stumac]

Hi Rob, you should have a look at this post:

http://www.microsoft.com/office/com...&p=1&tid=611750cc-ed86-4fd5-96d7-dda157728518


Stu