473,241 Members | 1,787 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Methoology for data changes being tracked

I need to be compliant with law that keeps a history of changes to tables as
records are edited. What is the best way to do this ? I was thinking a SQL
trigger on each table that writes to another change table on update (seems a
bit much), or use an OnChange event when ADO.NET posts to track the changes.
Is there a better approach to what seems a standard problem these days ?
Jun 2 '06 #1
1 1241
The only completely reliable way is to use the db triggers someone could
easily change the data in the db without going through your interface (or
someone could feasable modify your application to bypass the audit code).
That said, many people also use code level logging .. if are using something
like an object persistence framework (nhibernate etc) many have extension
points for things like logging. If youa re just using ADO and calling
inserts directly etc as opposed to a centralized framework I might lean
towards triggers as the code will get to be tough to maintain (as someone
could easily forget to put in an audit or miss an audit)

Cheers,

Greg Young
MVP - C#
http://geekswithblogs.net/gyoung
"Ronj" <Ro**@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...
I need to be compliant with law that keeps a history of changes to tables
as
records are edited. What is the best way to do this ? I was thinking a SQL
trigger on each table that writes to another change table on update (seems
a
bit much), or use an OnChange event when ADO.NET posts to track the
changes.
Is there a better approach to what seems a standard problem these days ?

Jun 3 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Vikram | last post by:
hi, i have a program which uses multiple threads and downloads pages using pycurl and processes these pages among other things. the program works fine with python 2.2 and pycurl 7.10.8 ; with...
0
by: Redd | last post by:
The following is a technical report on a data modeling project that was recently assigned to me by my professor. I post it so that anyone else who is studying databases and data modeling can have...
2
by: User 2084 | last post by:
Hello all. I'm an access newbie trying to learn how to do basic database data manipulations. I had a hard time searching the archives on this question as I don't really know what I'm looking for in...
1
by: Diane Yocom | last post by:
I'm still very new to ASP.Net, so wanted to get some advice on how to solve the following design problem (sorry my explanation is so long): I'm developing an ASP.Net intranet app (using VB.Net...
4
by: Paul | last post by:
Hi, I've been struggling with this today, I'm developing a DotNet2.0 website in C# that needs to call a long running data query. Obviously this is a good candidate for an Asynchronous call, so...
1
by: p.lavarre | last post by:
Is this interesting Python output? $ gc-object-already-tracked.py ********************************************************************** File...
1
by: suckerpunchnz | last post by:
Hi there, I'm using this audit trail code (basAuditTrail module) to log changes in my database, but I'm needing it to track by the user name logged into Access not by the account logged into...
0
by: Gert | last post by:
Inside my workflow "Workflow1" in CodeActivity "startActivity" I do : this.TrackData("Key", "value"); I can see in my SQL SqlPersistence DB in the UserEvent table the tracking value was added....
0
by: lcthree | last post by:
Hi, my question is about database design. I'm trying to design a database for a stock control program as part of a larger system. The problem I am having is that some items in the database have...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.