List of Users

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top