You receive a "File already in use" error message when you open a database on a server in Access 2000 (202171)
The information in this article applies to:
This article was previously published under Q202171 This article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user computers.
For a Microsoft Access 2002 version of this article, see 289681.
SYMPTOMSWhen you try to open a database that is located on a 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, 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.
If you are using a security-enhanced Access database, you must make sure that the users who open the database
also have Read permission and Write permission on the folder that contains the workgroup information (.mdw) file.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
210178
Contents of the Readme file for Access 2000
| Modification Type: | Major | Last Reviewed: | 7/28/2004 |
|---|
| Keywords: | kb3rdparty kberrmsg kbprb KB202171 |
|---|
|