>I am trying to pack (get rid of the deleted records) in a VFP table. using the adodb object.
That can't be done through ADO. If you have VFP installed on the PC you may be able to make a call to VFP as a server to execute the pack command on the current table. Notice I say "may" because I haven't tried it.
Or, create your own VFP exe that you can pass the table name to pack.