Archive Data in DataBase And COmpacting the DB

hi all, :bigyello:

i am crating am application in vb 6.0 after compliting all of my work in this application i have 3 Databases in access, now i want that After an order has been completely printed, we need a button on the screen called “Archive Order” that the user clicks to archive an order. We will ask the user for confirmation and if confirmed, we take all the scanned data for the order and MOVE it to an archive database ( database2) After the move we need to compact the database (database1).

How can i compacting and Move the data in database...

Regards,

Once you have the information regarding the order, "moving" it is as simple as doing an INSERT INTO one database and a DELETE in the other database.