I am working on a VB6 project using the DAO control to a .DBF file. I am trying to find a way to 'Compress' the data file after have run a SQL command to clear the Table. such as

sSQL = "delete * from pay"
DB.Execute (sSQL)

I do not wish to destroy the original table since I want to review the data after the program has stopped processing. <This is for debug purposes>

Any and all ideas are welcome.