?
Solved

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

Posted on 2010-11-17
4
Medium Priority
?
377 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 1000 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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 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