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

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"
bobdylan75Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Cristi_EConnect With a Mentor Commented:
Hi,
I think this will help:
http://support.microsoft.com/kb/198755

Cristi
0
 
HooKooDooKuCommented:
Try to open the database for "Exclusive Access".  If you fail to open the database, then someone else already has it open.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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
 
bobdylan75Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.