Log users that access database

[Les]

Good day, is it possible to create a log with the users name and date
that they access the database ?

 

[Guest]

Hi Les,

Yes, this is possible. One method involves determining the user's NTUserID,
using code found here:

Get Login Name
http://www.mvps.org/access/api/api0008.htm

Run this function at startup, and write the results to a table, along with
the current date & time (ie. the Now() function).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Les]

Hi Les,

Yes, this is possible. One method involves determining the user's NTUserID,
using code found here:

Get Login Name
http://www.mvps.org/access/api/api0008.htm

Run this function at startup, and write the results to a table, along with
the current date & time (ie. the Now() function).

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/e...http://www.access.qbuilt.com/html/search.html
__________________________________________





- Show quoted text -

Hi Tom,

Thank you so much for that.

Tom i am not a programmer but a dabbler, do you think you could walk
me through it ??

 

[Guest]

Hi Les,

It would be quicker for me to send you a working sample than to attempt to
walk you through it, especially since I don't know at what level you are
currently at. If you'd like to receive a working sample, then send me a
private e-mail message. My e-mail address is shown at the bottom of the
contributors page indicated in my sig. line. Whatever you do, please do not
post your e-mail address (or mine) to a newsgroup reply. Doing so will only
invite the unwanted attention of spammers.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________