users in a secured DB

[Eddy Maas]

Hi,

I.ve a secured DB and sometimes i have to get exclusive
rights to change something in the DB. But this DB is
shared on the network and at this moment i have the phone
everybody who has access to this DB. Is there a better way
so i can see who is in the DB. I've tried the sript in the
knowledgebase but that only work with unsecured DB.

Thanks in advance,

 

[Scott McDaniel]

There is an .ldb viewer available that will show you everyone who is logged
into your database. Google on "lbdviewer" and you should find it.

This is also a question frequently asked in the newsgroups. There are lots
of code snippets available that show you how to go about automatically
logging people out of the database when you need to make changes. It
involves using a form with a timer set to a particular interval (say 5
minutes), which checks for the existence of a file in a particular location.
Long as that file is there, the application stays running. If you want to
shut down the application, change the name of the file and the next time the
Timer event fires, your code won't see that file and will begin shutting
down the application (after suitably warning the user AND giving them time
to complete whatever task they are performing). It works, but make sure you
do NOT use a MsgBox ... if someone has left their application running and is
out of the office, their machine will simply display the MsgBox until they
come back and handle it, thereby leaving you in the same fix you are in
now!!

 

[Lynn Trapp]

First, you need to split your database, if you haven't already, and give
each user a copy of the front end for their hard drive. Second, do all
development work in a copy of the front end. When you are finished you
distribute a new front end to your users -- preferably after hours. If you
have to make changes to the back end, you should do those only at a time
when you don't have to worry about users being in the database.