You may receive a "file already in use" error message when you try to open an Access database that is located on a server (289681)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
This article was previously published under Q289681 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 2000 version of this article,
see
202171. For a Microsoft Access 97 version of this article,
see
183936. SYMPTOMS When 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.
Additionally, 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.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.
For more information about .ldb
files, click Microsoft Access Help on the Help menu, type sharing access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
REFERENCES
For additional information about .ldb
files, click the following article number to view the article in the Microsoft Knowledge Base:
299373
Introduction to .ldb files
| Modification Type: | Major | Last Reviewed: | 7/28/2004 |
|---|
| Keywords: | kbnetwork kbDatabase kbopenfile kb3rdparty kberrmsg kbprb KB289681 kbAudDeveloper |
|---|
|