|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Security Report -AccessI am trying to create a security log in MS Access 2003. What I am
trying to accomplish is to create a report of all the users who used the database (i.e. username, data & time). Ideally, I would liked to have the Windows login as the username. Any assistance in this matter would be greatly appreciated. -AB There is code at
http://mvps.org/access/api/api0008.htm you can use to grab the user's Windows login name. If you have some form that opens on startup (or create one that is hidden, if need be), you can append the username and use the Now() function for the date/time into a table. -- Show quoteHide quoteJoan Wild Microsoft Access MVP <arjun.baner***@gmail.com> wrote in message news:1193169481.560143.320510@i38g2000prf.googlegroups.com... >I am trying to create a security log in MS Access 2003. What I am > trying to accomplish is to create a report of all the users who used > the database (i.e. username, data & time). > > Ideally, I would liked to have the Windows login as the username. > > Any assistance in this matter would be greatly appreciated. > > -AB > 
Other interesting topics
Access 2007 user level security (lack thereof)
User-Level Security problem - app does not trigger logon screen Security Warning Access 2007 Error 2614 - User level Security Exclusive Use Error Error "Could Not Lock File" users over network 2. Application not found error block code re-engineering Do Table Permissions Override Query permissions? |
|||||||||||||||||||||||
