|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Audit on AccessHi People,
I am wondering if there is a way to audit access database and be able to track down who used the database, what changes were made and the time changes were made. This is a feature in many database applications and I am wonder if this can be done in Access. I know you can check who is logged in. Anybody please advise Billy You can only do this if you've set up the necessary code/tables to track it
beforehand. See Creating an Audit Log http://allenbrowne.com/AppAudit.html I'm not positive that URL is correct, but you'll find an audit trail sample somewhere on Allen's site www.allenbrowne.com -- Show quoteHide quoteJoan Wild Microsoft Access MVP Billy wrote: > Hi People, > I am wondering if there is a way to audit access database and be able > to track down who used the database, what changes were made and the > time changes were made. This is a feature in many database > applications and I am wonder if this can be done in Access. I know > you can check who is logged in. > Anybody please advise > Billy Thanks a lot Joan, you have been of great help. The coding on that URL
look overwhelming but, I will try it out and see what I come up with. I am glad I can do this. Billy Joan Wild wrote: Show quoteHide quote > You can only do this if you've set up the necessary code/tables to track it > beforehand. > > See Creating an Audit Log > http://allenbrowne.com/AppAudit.html > > I'm not positive that URL is correct, but you'll find an audit trail sample > somewhere on Allen's site > www.allenbrowne.com > > -- > Joan Wild > Microsoft Access MVP > > Billy wrote: > > Hi People, > > I am wondering if there is a way to audit access database and be able > > to track down who used the database, what changes were made and the > > time changes were made. This is a feature in many database > > applications and I am wonder if this can be done in Access. I know > > you can check who is logged in. > > Anybody please advise > > Billy |
|||||||||||||||||||||||