Make-Table Queries

[millers92]

I am using a make table query to create an archive table of records that are old but still need to be available through the current db. I understand how to create this, but I do not want Access to delete the table that is there everytime I run the make table query. Is there a way I can prevent it from doing so?

Steve

 

[Nouba]

once the table exists use an update query instead of the maketable query.