Solved

Data Change Tracking In an Application

Posted on 2007-11-14
3
611 Views
Last Modified: 2012-08-13
We  build applications with Access front ends and SQL 2000 backends. One of the requests we get frequently is to track when data is changed and who changed it.  Currently to do that we put code behind EVERY field to get the old value compare it to the new value and then if it is different put the information in a record log table. We then create a form so Management can search and view the changes.   I am sure there has to be a better and easier way!

I know SQL has a transaction log but is that something I can link into an application to display changes in a particular DB? Does anyone have any ideas? it will take me about a week to do it the way we have been so far. . Here is what our log end up looking like now

recordLog
Log_Seq      LogID      LogDate      FieldName      Was      Is      SubSeq      MainSeq      FormName
48394      Amelia Power      05/16/2007      Received      0      -1      10371      6302      BackGround Check Information
0
Comment
Question by:PSIUnit
[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
3 Comments
 
LVL 42

Accepted Solution

by:
Eugene Z earned 500 total points
ID: 20280845
I would recommend 3rd party tools (www.idera.com)
but
you can try to use audit triggers:
http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html
--
Generic audit trail trigger
Author Nigel Rivett
http://www.nigelrivett.net/AuditTrailTrigger.html
0
 
LVL 14

Expert Comment

by:twoboats
ID: 20280954
Ditto.

The tran logs won't help you - without a 3rd party tool to read them.

You could enable c2 auditing, but it uses lots of space, and the info of who changed what isn't available to queries.
0
 

Author Comment

by:PSIUnit
ID: 20281017
I will research these and get back.. a third party software sounds great if i can swing the funding..

Thanks
0

Featured Post

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

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Using datetime as triggers 2 27
How do a DCount on a report 1 18
Importing cr/lf as text in sql server 7 18
Email question 12 25
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

730 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