?
Solved

Audit log in Access database 2007

Posted on 2010-09-24
7
Medium Priority
?
708 Views
Last Modified: 2013-11-27
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



           
0
Comment
Question by:angel7170
  • 4
  • 2
7 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 33755350
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
 
LVL 33

Expert Comment

by:jppinto
ID: 33755359
"put the necessary lines of codes" ...on your VB application to write to the database.
0
 
LVL 33

Expert Comment

by:jppinto
ID: 33755366
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:angel7170
ID: 33755369
Thanks

Any suggestion on how to write the code?
0
 
LVL 33

Accepted Solution

by:
jppinto earned 750 total points
ID: 33755419
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 750 total points
ID: 33755445
see this link
Creating an Audit Log
http://allenbrowne.com/AppAudit.html
0
 

Author Closing Comment

by:angel7170
ID: 33906195
Your suggesstions is helphul..
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question