I can create the backup of a table but I would like to update the backup every quarter. Is there an example of how to do that somewhere? I am using MS-Access and ASP.Net 2. Here is the code I use to make the initial backup. When I click the button is says table already exists.

You should be using a INSERT statment, I'm not sure about the syntax but it look like this: INSERT INTO table1 (fields) SELECT fields FROM table2

 If it's a backup table, why not just copy the .mdb file ? If your database gets corrupt both table will be corrupt.

SELECT...INTO... command will create a new table to host the result set returned in the SELECT list. If you want to append recoreds to the backup table, you can use the INSERT INTO...SELECT command as ThE_IOtUs said; if you want to update the backup table to the last version, you need to delete the previous rows and then insert new rows, as UPDATE ...SET...FROM...WHERE command seems to be not supported in Access.

I'm really archiving the quarterly reports for one table and not the whole database. I will try what you suggested above.

thanks;

Thanks again and its work great. If you don't mind if I wanted to update two fields, in all the records, in the table, how do I create a routine that does that? Any help would be great.

thanks;