Microsoft KB Archive/308633

= ACC97: &quot;File Already in Use&quot; Error Message When You Share an Access 97 Database on a Windows 2000 Server-Based Computer =

Article ID: 308633

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q308633



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
On a computer that runs Microsoft Windows 2000 Server, when a second user tries to open an Access 97 database (an .mdb file) that you share, the following error message may appear:

Couldn't use. File already in use.



CAUSE
This issue can occur if the user does not have appropriate permissions to the shared folder where the .mdb file resides. In Windows 2000 Server, this can happen if the second user is a member of the Users group. By default, the Users group for Windows 2000 Server has Read-Only permissions to the share where the .mdb file resides. As a result, Access 97 cannot create the .ldb file that is necessary for the user to use the shared .mdb file.



RESOLUTION
To resolve this issue, grant the Users group the appropriate permissions to the folder where the .mdb file resides:
 * 1) Make sure that no other user has the database open.
 * 2) Under the permissions for the folder, remove all groups except those for which you plan to grant explicit permissions.
 * 3) Grant the Users group Read, Write, Create, and Delete permissions for the folder.
 * 4) If an .ldb file still exists in the folder where the .mdb file resides, delete the .ldb file.



MORE INFORMATION
For additional information about permissions and .ldb files, click the article number below to view the article in the Microsoft Knowledge Base:

136128 ACC: Introduction to .ldb Files (95/97)

Additional query words: pra prb

Keywords: kberrmsg kbprb kbsecurity KB308633

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.