renaming tables

K

KK

I want to use one of the standard projects supplied with Access and modify
it for my own needs. I will need to change table names.. This presumably
will upset the queries & forms etc based on those tables. Is there a way of
changing a table name and all its references throughout the database?

Thanks

KK
 
T

Tom Lake

KK said:
I want to use one of the standard projects supplied with Access and modify
it for my own needs. I will need to change table names.. This presumably
will upset the queries & forms etc based on those tables. Is there a way
of
changing a table name and all its references throughout the database?
Click to expand...

If you're using Access 2003, it will automatically update all references to
tables in queries, forms, etc.

Tom Lake
 
E

Ed Robichaud

For Access 97-2002, there are two commercial products (perhaps more) that
run as add-ins and will do a global find and replace for object names -
Speed Ferret and Find & Replace. I believe there is a shareware version of
the later. Try www.rickworld.com
-Ed
 
Top