Thank
>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.