Solved

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

Posted on 2010-11-17
4
372 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

773 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