General information
Category:
Coding, syntax & commands
Title:
How to 'Pack' a MS Access database
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only