Replacing one table by another one automatically

[nqueen]

Hi,

In my database, I have many queries and tables dependent to one specific table. The problem I have is that that specific table needs to be changed. Is there a way to automatically replace that table in all queries by another one without having to go through all queries to change it manually?

 

[PHV]

You may try something like this:
Create your new table
Rename the old table
Create a query named like the old table but selecting all from the new table

BTW, can't you simply apply the changes to the actual table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886