Solved

Audit log in Access database 2007

Posted on 2010-09-24
7
691 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:angel7170
ID: 33755369
Thanks

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

Accepted Solution

by:
jppinto earned 250 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 250 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

733 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