Users in DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Naz - 11 Jan 2008 13:35 GMT

Hi

I have a database in a shared location with multiple users accessing it. Is
there any way for me to know who's is currently accessing it.

Thanks for any help

Signature

_______________________
Naz,
London

Reply to this Message

Al Campagna - 11 Jan 2008 14:09 GMT

Naz,
Try the CurrentUser function.

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

> Hi
>
[quoted text clipped - 3 lines]
>
> Thanks for any help

Reply to this Message

Douglas J. Steele - 11 Jan 2008 14:35 GMT

Are you saying that within the application, you want to know who the current
user is (so that, for instance, you can put a "LastUpdatedBy" value in the
table), or are you saying that you need some way of knowing all of the users
currently using the application?

For the former, Al's suggestion of CurrentUser will only return something
used (i.e.: something other than "Admin") if you've applied Access
User-Level Security to the application, so that users are required to lock
into the application. If all you want is their Network ID, check
http://www.mvps.org/access/api/api0008.htm at "The Access Web".

For the latter, check http://support.microsoft.com/?id=198755 (while it only
mentions Access 2000 in the title, it applies to Access 2000, 2002 and 2003.
For Access 2007, using the accdb format, you'll need to use
Microsoft.ACE.OLEDB.12.0 as the Provider)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi
>
[quoted text clipped - 3 lines]
>
> Thanks for any help

Reply to this Message