"Pack table1" should work, although you probably need to close the connection and re-open before issuing the pack. You may even need to set the connection object to nothing and then re-connecting if you keep getting the "file in use" error message. HTH


>Hmmm I tried that and the new connect string was accepted as valid, but I still encountered the same problem when I try to issue a Pack command via the Ado.Execute method
>
>Maybe I'm going about this the wrong way...?
>
>Anyway I have a VFP database container (with tables) .dbc accessed thru ODBC, so I open an ado connection like so:
> ado.open "dsn=jas_data;exclusive=yes"
>
>When I write the following command:
> ado.execute "delete * from table1.dbf"
> ado.execute "pack"
>
>the 2nd line fails with an error message stating that it should be opened as exclusive. If I use "pack table1.dbf" instead, I get an error saying the file is in use.
>
>Any ideas...? (although I'm pretty sure I'm actually using the PACK command wrong here...)
>
>Thanks much!