Hi.
I am using ADO and Cursor Adaptors to update
an Access table and its working fine. My pseudo Code is as follows:
Sele MyAccessCur
Delete All records
Append from MyVFPTBL

This gets all the data into the Access Table and its working fine.
The only thing I notice is that the Access Database starts to bloat, probably because I am deleting all and then appending in from my VFP table. (This happens to be the easiest way to update from the VPF data)

Now , I can got into Access , into Tools, into Data Utilites and select an option to Compact & Repair, which seems to do a 'Pack' and redueces the bloat.

Is there a way programtically, say using ADO or something else to do the same thing from within my VFP program. (The Customer may not have a copy of access and may not be able to run the repair utility... anyway I'd prefre to automate this if possible)

Any help appreciated.
regards,
Gerard