At startup, or during certain actions such as adding catalog paths or a parts database path, error messages are displayed indicating that a file with a .mdb extension is already opened or locked by another user. Possible error messages include:
WarningThe catalog is currently being edited by another user:
Catalog path ...MyCatalog\catalog.mdbLocked by user: (other user's login name)
Press Retry to try again.
Internal ErrorError Message: Could not use'';file already in use.TargetSite: Int32 NewConnection(System.String)DeclaringType: MDBProxy.ConnectionManagerAttributes: internalMemberType: Method
The messages could be resulting from another user exclusively opening a .mdb database that may be noted in the error message. When a user does not have sufficient rights to the folder containing the database, they cannot create or write to the .ldb file that is supposed to be created to allow multiple users to access the database. Therefore they open the database exclusively, preventing other users from accessing the database.
Per the Microsoft Knowledgebase article http://support.microsoft.com/kb/289681: "To prevent this behavior, 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."