Audit log in Access database 2007

Hello,

How to track changes made to an record in Access Database using VB.Net Windows application

I would need the below information stored in a different table

LogId- Unique
Item - Change made for this "Item"
Field Affected - Name of the field that has been changed
Old Value - Value before the change
New Value - Value after the change
User - Who made the modification
Date -  When was the change made

Any suggestion or ideas, please?

Thank you



           
angel7170Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jppintoConnect With a Mentor Commented:
How are you writing to your database? Just need to add the fields that you want to fill to the code you use to write to the record and fill it with the information that you want to store. It's a bit hard to give you a sample code for this without knowing how are you writing to your Access database tables...
0
 
jppintoCommented:
You just need to create the fields on the tables you want to record this information and put the necessary lines of code to write to this fields on each record, each time the record is changed.

jppinto
0
 
jppintoCommented:
"put the necessary lines of codes" ...on your VB application to write to the database.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
jppintoCommented:
You can make a specific table to record the log information but it's easier to read if you put the information next to the record.
0
 
angel7170Author Commented:
Thanks

Any suggestion on how to write the code?
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this link
Creating an Audit Log
http://allenbrowne.com/AppAudit.html
0
 
angel7170Author Commented:
Your suggesstions is helphul..
0
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.

All Courses

From novice to tech pro — start learning today.