"Cascade" field and table name changes

[dee]

Hi all,

Am working with AYS database, trying to take the ideas and re-work them to
fit my own needs.

Because of another software I will be using in conjunction with Access, I
have to use different naming conventions, plus would like to use my own names
for tables and fields.

I know that in queries, forms, etc., that are already set up, Access will be
looking for the original names. Is there any way that I can, not too
painfully, "cascade" my field and table name changes?

Thank you.

 

[Jerry Whittle]

Rich Fisher's excellent Find and Replace is just the ticket.

http://www.rickworld.com/

If you register it (one of the best $37 I've ever spent), the
cross-reference report can find what queries use which reports and forms.
It's a good way to find orphans.

 

[dee]

Thanks for the advice. I'll check it out and see how it works!

 

[dee]

What can I say - THANK YOU!!! What a great add-in. You just saved me days
of work! You're a saint!

 

[Jerry Whittle]

The praise belongs to Rick Fisher. Please consider registering the program.