Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 289580 - Last Review: March 26, 2007 - Revision: 5.1
How to determine which user has opened a database exclusively in Access
This article was previously published under Q289580
Moderate: Requires basic macro, coding, and interoperability
skills.
This article applies only to a Microsoft Access database (.mdb or .accdb).
Unlike Microsoft Access version 2.0 and earlier, Access 2000
and later versions do not create a .ldb file when a
database is opened exclusively. Because of this, you can no longer use the .ldb
file to determine which user has a database open for exclusive use.
When you try to open a database that is opened exclusively
by another user, you receive the following error message:
Couldn't use '<path>\<database.mdb>'; file already in
use.
You receive no information about the user or the computer
name.
In order to determine which user has a Microsoft Access 2000
or later version database open exclusively, you must
use an operating system tool, such as the
Microsoft Windows 2000 or
Windows Server 2003 Computer Management utility.
To
open Computer Management, follow these steps:
- Click Start, point to
Settings, and then click Control Panel.
- Double-click Administrative Tools, and then double-click
Computer Management.
- In the management console, expand
System Tools, and then use Shared Folders to manage
shared resources over a network.
By using Shared Folders, you can control user
access permissions, session activity, and shared resource properties.
For more information about using the Microsoft Windows 2000 Computer
Management utility, click
Start, click
Help, click the
Index tab, and then type
Computer Management in
the keyword box.
For additional information about
.ldb files, click the following article number to view the article in the
Microsoft Knowledge Base:
299373Â
(http://kbalertz.com/Feedback.aspx?kbNumber=299373/
)
Introduction to .ldb files
For additional information about determining which users are
logged into a database, click the following article number to view the article
in the Microsoft Knowledge Base:
285822Â
(http://kbalertz.com/Feedback.aspx?kbNumber=285822/
)
How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2002 or in Access 2003
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
- Microsoft Access 2000 Standard Edition
| kbenv kbhowto kbnetwork KB289580 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate