Hello,

You can execute the following command using Connection object:
"SET EXCLUSIVE ON;PACK MyTable"
An ODBC sample is provided in Q234756.


>Hi,
>
>My VB6 application is using dbf file with ADO 2.6 for access.
>I using connection & recordset to access the dbf file
>
>After I had delete the record in the dbf, I cannot pack
>the dbf file using my VFP written DLL library as I not
>yet close my connection since I looping through the same
>folder deleting only some file data.
>
>Any better way to solve my issue or way to
>pack dbf with their cdx file in VB6 using
>ADO 2.5 ?
>
>Any help or advise is very much appreciated.