[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

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
0
MAS
Asked:
MAS
  • 6
  • 6
  • 2
1 Solution
 
AndyAinscowCommented:
>>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
 
MASTechnical Department HeadAuthor 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
AndyAinscowCommented:
>>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
 
MASTechnical Department HeadAuthor 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
 
MASTechnical Department HeadAuthor 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
 
MASTechnical Department HeadAuthor 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
 
MASTechnical Department HeadAuthor Commented:
Thanks
0
 
hnasrCommented:
Welcome!
0
 
MASTechnical Department HeadAuthor 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now