>>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.
The VFP com object may be the best answer. I will do that and post the dll to VB files section and the source to the VFP files.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams