ACC2000: "File already in use" Error Opening Database on Novell

ID: Q202171

The information in this article applies to:

Microsoft Access 2000

This article applies only to a Microsoft Access database (.mdb).

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you try to open a database that is located on a Novell NetWare server, you may receive the following error message:

Couldn't use <filename>; file already in use.

CAUSE

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 (*.ldb) 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.

RESOLUTION

To prevent this behavior, make sure that all users who open the database have read, write, and create rights for the folder in which the database is located.

MORE INFORMATION

In order to open a database in shared mode, the Microsoft Jet database engine must be able to create a locking information file (*.ldb) in the same folder as the database itself.

Additional query words:


Keywords          : kb3rdparty kberrmsg kbdta EvnNtw GnlMu 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 17, 1999