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!