Results 1 to 3 of 3

Thread: Compact tables

  1. Jul 9th, 2004, 01:56 PM #1
    jwingenb
    jwingenb is offline

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Posts
    2

    Compact tables

    Greetings all,

    I hope someone out there has the answer I am looking for. I wrote a program in VB.net that will combine multiple dbase tables. This program is designed to run daily and it deletes its contents and combines all the tables every day. The problem is that the master table keeps growing because all the deleted records are not actually gone. Does anyone know how to compact or pack a dbase table?
    Reply With Quote Reply With Quote
  2. Jul 9th, 2004, 03:22 PM #2
    Pirate
    Pirate is offline
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083
    There's no pure .NET code that can do this , yet you can use ADOX to compact your db .
    Reply With Quote Reply With Quote
  3. Jul 9th, 2004, 03:25 PM #3
    Pirate
    Pirate is offline
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083
    btw , can you delete the other thread . This keeps the forum neater .
    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