Re: Locked database
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Wed, 28 Nov 2007 15:47:10 -0500
I don't think it's possible.
Access is going to complain about the fact that the second person can't get
in properly before you'll have a chance to.
And there's no easy way to determine the ID of other users in the database,
just their computer name.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Erik" <Erik@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9D6F55D6-5126-484F-9FF0-752CC542336E@xxxxxxxxxxxxxxxx
I have a database that i have open exclusive and when one person opens it
and
another wants to open it i would like to show a msgbox that tells that
person
that
that it is locked by this user.
"DCPan" wrote:
No sure what you are asking exactly.
Here's code that would grab who's logged in:
http://www.mvps.org/access/api/api0008.htm
But, if you want to know who's locking the database up while you are
trying
to use it, that's different.
"Erik" wrote:
I would like to know if there is a way to have a msgbox open up when
you open
a locked database and display the windows login name? Thanks for any
help you
can give.
.
- Prev by Date: Re: Problem with INSERT INTO (SQL) statement in VBA
- Next by Date: Re: Ping IP Addresses
- Previous by thread: Problem with INSERT INTO (SQL) statement in VBA
- Next by thread: Re: Ping IP Addresses
- Index(es):
Relevant Pages
|
