Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Audit log in Access database 2007

Posted on 2010-09-24
7
Medium Priority
?
703 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

722 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