Renaming table in a dB

R

Ramesh

Is there a short way in which i can modify all references to a table after i
rename it? Or would i have to open every query and form and manually change
the table references?

Thanks
ramesh
 
A

Allen Browne

Actually, I should have been clearer about that.

Access 2003 and 2007 do allow you to list the dependencies between objects.
However, this requires Name AutoCorrect to be turned on, and that is likely
to corrupt your database, so I suggest you do that in an unimportant backup
copy only. Even then, you may not be able to get it to work without
crashing, particularly if some of the dependencies are invalid (e.g. a query
that uses a table that is no longer in the database.) That's why I say,
"Access doesn't provide a way to do this."

If you are using Access 2003 or later, see help on object dependency. In
Access 2007, it is help topic HV10037656 (from the VBA window.)

For info on the problems with Name AutoCorrect, see:
http://allenbrowne.com/bug-03.html
 
R

Ramesh

Thanks very much Allen. I wudnt think it wud be worth such effort and risk.
I d either live with the existing names or plan out the manual changes.

And i really thank you for the treasure of tips on your site. I ve been
falling in love with Access after i started learning from your site.

Great work of contribution!

Ramesh
 
Top