Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT INTO causes File is in use error
Message
From
22/12/1998 12:55:55
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00169703
Message ID:
00169717
Views:
21
VFP need to lock the header of the table a fraction of a second when adding new record. If another user try to insert a record while another user as a lock on the header, you get a error message.

2 suggestions:
- Turn on record/table buffering and check the result of TableUpdate() (my preffered choice)
- Issue a RLock(0) before inserting the new record and release it afterward. RLock(0) will lock the header of the table

HTH

>My users are intermittantly getting a "File is in use by another user." error when they do an INSERT INTO a table in my DBC. There are a few users in the application at the same time. I have SET EXCLUSIVE OFF. This problem did not seem to happen before I added the table to the DBC (was stand-alone before that).
>
>I am opening the table in the form's load event with:
>IF NOT USED('CheckProcessorLog')
> USE data\CheckProcessorLog IN 0
>ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform