General information
Category:
Database DAO/RDO/ODBC/ADO
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.
Previous
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