Based on Logname

[Dgavilanes]

Hi All,

I would like to create a logname of people using the database, and being able to report their transactions by date

How will I do this

thanks

Dennis

 

[dcx693]

If you're using Access security, you can use the CurrentUser() function to get the name of the current logged on user. If not, you'll need to use a Windows API call to get the name of the name of the user from Windows.

You'll need to create a log table, or add fields to your current tables, capturing the name of the user and the date they made the transaction. Update the log table or fields by placing code into the Before Update events on your forms, and of course, make sure your users on alter data via forms. If you must run action queries, that might be a problem, unless you are only running update queries or "wrap" those queries and execute them from within code that also write to the log table.

 

[Dgavilanes]

Re:

Thanks for your replied

I done security before so I can relate to that.

Because I'm sort of new with this everything else you mention "went over my head"

sorry


Dennis

 

[Lynn_AccessUser]

Try this website. There are 2 AuditTrail db that I have referenced to track the users and the changes they made. Will need to make a few changes to get it to work, but this should at least get you on your way.

http://www.rogersaccesslibrary.com/TableOfContents2k.asp