We have a real time process and i have to log all the data periodically into an Access database using VB6 as front end for reporting purposes.

The problem is that the size of the database increases drastically so i purge the data after 30 days (Delete the records older than 30 days).

But i observed that the database size does not reduce even after purging the records.

What do i need to reduce the size of the database ?

Datamanager allows me to compress the database to a new file. How Can i comperss the database from VB ?

I also need to send the database file after zipping & compressing it to the floppy drive how can i do it from VB6 ?

Jaspal Muker