Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open ADO exclusively
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00735335
Message ID:
00735762
Views:
10
Just a shot in the dark -- you've opened the database exclusively, but is it possible that the "exclusive=yes" refers to the database but not to the individual tables (I know it sounds odd, as I said, just a shot in the dark).

So maybe try this:
ado.execute "use table1.dbf exclu"
ado.execute "pack"


>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!
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
Previous
Reply
Map
View

Click here to load this message in the networking platform