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?

There's no pure .NET code that can do this , yet you can use ADOX to compact your db .

btw , can you delete the other thread . This keeps the forum neater . :)