Hi Al
Thanks for thos links.

Regards,
Gerard




>>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)
>
>Re: Compact a MDB file using ADO or SQL Thread #688777 Message #688968