I do not know what your particular needs are, but, in general, tables are not packed everytime a record or group of records are deleted. Our apps usually have a setting of SET DELETED ON that hides deleted records in our tables. Our apps usually have a maintenance function that packs tables during off-times and is usually performed by the manager of the app.

If you check with the developer of the VFP database and app, you may find that packing is not needed.

>Thanks for the hyperlink. Maybe you can check this:
>I tried the following code:
>
>Private Sub Command1_Click()
> 'de is a DataEnvironment
> 'con is a ADODB.Connection
> de.con.Open
> 'Next instruction is like the C instruction on the hyperlink
> de.con.Execute "SET EXCLUSIVE ON;PACK inmuebac"
>End Sub
>
>I get an error: "File is in use".
>The error is returned by ODBC Microsoft Visual FoxPro Driver.
>The file is closed, and I didn't open it before the code above.
>
>Any help from you will be useful!!!
>
>Thanks again.
>
>
>glurrea