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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only