>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
>
>What am I missing?
>
>Thanks!
What is SET REPROCESS setting in your application. You may try to use SET REPROCESS TO AUTOMATIC
Edward Pikman
Independent Consultant