renaming tables

  • Thread starter Thread starter KK
  • Start date Start date
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
 
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
 
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
 
Back
Top