List of Users

  • Thread starter Thread starter NoviceIan
  • Start date Start date
N

NoviceIan

Hi,

We have a split database over several sites with some 20 users.

We need exclusive access to the database at certain times to run automated
updates. These updates are frequently failing because some of our users
leave their desks with the database still on!!

We need an easy way to identify who has the database open at any given time.
However we don’t have any security on the database. The only thing we do
have is a lastupdated field using the environ command which traps the windows
log in of the last person to update the record.

It would be really useful if we could run a query which would give us a list
of all users with the database open. Not sure if this is possible thou so
any help would be very appreciated.

Many thanks
 
If you don't have Access User-Level Security applied, then it's not really
possible.

Access only tracks Access User information. In the absence of ULS, that
means every person using the database will be identified as admin (the
default user). The best you can hope for is to identify the name of the
computer on which the user is logged.
 
Back
Top