Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table is in use by another user
Message
 
 
To
21/08/2002 13:12:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00692079
Message ID:
00692291
Views:
19
Hi Mark,

INSERT command places lock on the table header for duration of the insert. If table or it's header is locked by another user, you'll get Error 108 'File is in use by another user'. You can use SET REPROCESS TO command to control how long VFP tries to lock record after unsuccessful locking attempt.
If table open exclusively by somebody else, you wouldn't be able open it and would get Error 1705 'File access is denied'.

>I have a program that does an extensive INSERT (going thru a loop) INTO a table on network. That table is opened before the loop so there is no way someone opens that table exclusively. Once in a while I am getting a message in a question. Any idea?
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform