Error:

could not use; file already in use

Snapshot:

Causes:

If a user opens a database and doesn’t have create rights for the folder in which the database is located, the Microsoft Jet database engine can’t create the locking information file that is necessary for multiple users to open the database. Therefore, a user who doesn’t have create rights opens the database exclusively if a corresponding .ldb file does not already exist.

Workaround 1:

You must make sure that all users who open the database have read, write, and create rights for the folder in which the database is located.

Workaround 2:

it is necessary to set the Write permission to the whole folder where the MDB file is stored.