User List

[Andrew]

Can any one help me with this problem please?

I'm writing a little Access app and would like it to know
automatically who
is currently editing the database. Now I realise you can do this
easily with user accounts. The trouble is I've set up my users and
when the DB is opened it asks for a name and password. Security is not
an issue, I'd just like it to capture a name, so passwords are
defaulted to nothing. Ideally it would present a drop down list of
users instead of asking the name to be typed in. Is this possible?

Thanks in advance for any help.

Andrew

 

[BillD42]

Andrew,

I'm not sure I understand exactly what your looking for but,
the "currentuser" method of the app object will return the currentuser name.

example:
MsgBox("The current user is: " & CurrentUser)
Hope this helps, Bill