Results 1 to 2 of 2

Thread: Archive Data in DataBase And COmpacting the DB

  1. Feb 2nd, 2006, 04:36 AM #1
    nileshhthakur2004
    nileshhthakur2004 is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2005
    Posts
    152

    Exclamation Archive Data in DataBase And COmpacting the DB

    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,
    Nilesh Thakur.
    Reply With Quote Reply With Quote
  2. Feb 2nd, 2006, 06:44 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Archive Data in DataBase And COmpacting the DB

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width