Table Overwrite

[ml2009]

If I overwrite table A with table B, it has the same fields/structure as table A, and name it the same as table A, will existing queries that read from table A work correctly?

[ConneXionLost]

Hi ml2009,

One solution is to use a delete query to remove the data from Table A (this will leave the table structure and relationships intact), then use an append query to add the new data from B to A.

Cheers,

[NTC]

if there are fixed relationships to the table - - you won't be able to delete it or change its name without first dealing with those relationships.

but otherwise, yes, replacing a table with another table of the same name will not cause the queries to change....they will work when you run them....

[ml2009]

Thanks, Didn't want to change the relationships....i'm glad I didn't delete it yet. The append query worked great.

Many Thanks!