Audit on Access database

I would like to enable audit on my access database.
I tried with few examples which I got after Googling.

I attached both the database(my db and sample DB). I appreciate if someone can help/guide me or do the same in my DB and post back as I tried so manh times with no success
AuditTrail-Simple.accdb
Att-System-3.accdb
LVL 30
MAS (MVE)EE Solution GuideAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndyAinscowFreelance programmer / ConsultantCommented:
>>I would like to enable audit on my access database.

I think you should elaborate on that - just what do you mean with audit ?
0
MAS (MVE)EE Solution GuideAuthor Commented:
I would like to track the activity in the database.
Please check the attached databases I uploaded my database and the sample database I got from internet which has already auditing enabled
0
hnasrCommented:
Check this database.

Applied the action to form LeaveDataentry and Form Field File_No.
baseAudit module, and table: tblAuditTrail added.
Added Microsoft ActiveX Data Object Library; check references.

Check Form Before Update event
Select the field you want to audit, got to properties, other Tag: Audit.
Compare with File_no field.
Att-System-3.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

AndyAinscowFreelance programmer / ConsultantCommented:
>>I would like to track the activity in the database.

First - I hope you realise this will only track the changes you explicitly code it to track.  Anyone can make changes directly to records unless you implement security on the database, those changes will not be tracked.

Second - The example database shows you how to implement those changes.  When a change to a record via a form is to be made you just call the routine to write an entry into the log about what is being changed and by whom.
0
MAS (MVE)EE Solution GuideAuthor Commented:
@AndyAinscow
For me that is enough for now.

@hnasr
I cannot apply this on subforms. I have one more form which has subform.
How to do the same on subform?
0
hnasrCommented:
Which subform you are referring to?
0
MAS (MVE)EE Solution GuideAuthor Commented:
This as an example.
Attached a sample
I want changes in the subform to be audited/logged
Att-System-3.accdb
0
hnasrCommented:
Please note that the question was about implementing the solution in your database. The sample was not dealing with subforms.

For any extra requirement, you need to start a new question.
0
MAS (MVE)EE Solution GuideAuthor Commented:
0
hnasrCommented:
Grade this question to close.
Then you need to upload the final copy of the database including the new table and the module.
There should be a working example for the main form, and you need to extend functionality to subform.
0
MAS (MVE)EE Solution GuideAuthor Commented:
Thanks
0
hnasrCommented:
Welcome!
0
MAS (MVE)EE Solution GuideAuthor Commented:
Appreciate if you can help me on the other issue which is posted above with a new question
0
hnasrCommented:
Sure!  I'll give it a try later.

Edit: Done
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.