Renaming tables

[mhmaid]

hi ,
I have made on db two years ago when i was very new to access, now , i am
trying to reconstruct the db , delete unused objects , and remaming many
objects.

my question is , if i rename a table , what about the queries and other
ojbects that depends on it ,do i have to open them one by one to change the
source name.

any idea?

 

[Duane Hookom]

Tony Toews has links to some third party "Scan and replace utilities" that
can help you do this at http://www.granite.ab.ca/access/thirdparty.htm.

 

[cmagro]

I would check out Duane's link because I had the same problem and had to
change all the names manually. Pain in the neck, but fortunatly it was a
small enough database to not be overwhelming.