Change tables without rewriting the query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
When I replaced the tables underlying a query in Access 2003 with new tables
of the same names, the querry ceased to work - it could not find the tables.
Is there a way to change the tables without having to re-write the query
every time?
Thanks.
David
 
David

Can you write a new query on the new table and have it work?

Are you saying you need to eliminate the old table because you have a new
structure, or are you saying you have the same structure but new data? If
the latter, you can use delete and append queries to "reload" the table.
 
Back
Top