Solved

Ms Access: how to know, via VBA, if another user is using the database at the moment

Posted on 2010-11-17
4
371 Views
Last Modified: 2012-05-10
Hi,

Ms Access 2000/.../2010: how to know, via VBA, if another user is using the database at the moment?
How to know if the database is currently already open?
Thanks
somethink like that: if currentdb.alreadyopen then msgbox "yep"
0
Comment
Question by:bobdylan75
4 Comments
 
LVL 16

Expert Comment

by:HooKooDooKu
ID: 34154845
Try to open the database for "Exclusive Access".  If you fail to open the database, then someone else already has it open.
0
 
LVL 4

Accepted Solution

by:
Cristi_E earned 250 total points
ID: 34154852
Hi,
I think this will help:
http://support.microsoft.com/kb/198755

Cristi
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 34156809
Here are some links that will show you everyone who is logged in:

Here are some links:

How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
http://support.microsoft.com/?id=198755

Who's logged in?
http://www.mvps.org/access/general/gen0034.htm

LDB Viewer Form
http://www.mvps.org/access/modules/mdl0055.htm

Also attached is an MDB that is sort of a combination of the above, that will load the logged in users into a table.

mx
WhoIsConnected.zip
0
 

Author Closing Comment

by:bobdylan75
ID: 34162644
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now