hi all,

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,