Product(s):	Promis.e, Bentley Substation
	Version(s):	through 08.11.13.96
	Environment:	N/A
	Area:	Installation/Configuration
	Subarea:	N/A

Error or Warning Message

At startup, or during certain actions such as [[Add Catalog Path|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:

Warning
The catalog is currently being edited by another user:

Catalog path ...MyCatalog\catalog.mdb
Locked by user: (other user's login name)

Press Retry to try again.

and

Internal Error
Error Message: Could not use'';file already in use.
TargetSite: Int32 NewConnection(System.String)
DeclaringType: MDBProxy.ConnectionManager
Attributes: internal
MemberType: Method

Explanation

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.

How to Avoid

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."

External Links

http://support.microsoft.com/kb/289681

Original Author:

Matt_P