Solved

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

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

747 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

16 Experts available now in Live!

Get 1:1 Help Now