Message when database is already open by another user

[johan]

Hello,

Question-1:
If a multi-user database is already opened by somebody I want that,
when another person opens the same database, he (the second one) get
an popupmessage "Database Already In Use". This message is only for
info. The second user is also allowed to edit.

Question-2:
(Nice to have) Is it possible that the first user can get also a
message that another user opens the database so he knows that he's not
the only one in the database at that moment ??

regards,

 

[Tony Toews [MVP]]

If a multi-user database is already opened by somebody I want that,
when another person opens the same database, he (the second one) get
an popupmessage "Database Already In Use". This message is only for
info. The second user is also allowed to edit.

Check for the existence of the .LDB file on the backend MDB. Not
perfect but it will work 99% of the time. You can use DIR or API calls
as found at vbnet.mvps.org.

(Nice to have) Is it possible that the first user can get also a
message that another user opens the database so he knows that he's not
the only one in the database at that moment ??

See the third paragraph at Determining the workstation which caused
the Microsoft Access MDB corruption starting with With Access 2000 or
2002 ...
http://www.granite.ab.ca/access/corruption/workstation.htm

Tony


--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[johan]

Works well as a separate database. Just what I needed.
I shall try to implement it in my database.
thanks.

regards