i have written a vbce program for use in retail POS type environment. The system uses an access database to record sales, then when it syncs this database with the desktop a routine on the desktop copies the sales data into a master table and zaps the original (on the desktop), so that on next sync the sales that have previously been successfully transfered are deleted from the ipaq... However, although the database on the ipaq now contains no records the size of the file doesn't change. When more sales are added the file size doesn't grow (deleted record slots are being reused). This isn't ideal because the database will always be the same size as the largest it has ever been (unless I remove the syncronisation, and then add the table back to the handheld).
Is there a way in VBCE to pack or optimize a CDB database?
Is there a way in VBCE to pack or optimize a CDB database?