Solved

Best way to track data changes

Posted on 2008-10-25
2
194 Views
Last Modified: 2013-11-29
I am looking for the best way to track data changes. Basically I will have some users entering data into a form but on a weekly basis I have to QA the data. What I want to be able to do is change the data but still keep the old data so the end user can see what the data is changed from and changed to.

My table has 2 fields that would require changes named Process and Cause. I would like to create 2 new fields called qaProcess and qaCause that would store the old data. The correct (or corrected) information should remain in the original Process and Cause fields for reporting purposes. What is the best way for me to move the incorrect data from one field to another. Is this the best way to go about it? Should I consider using a separate table to capture this data?

Only about 1 in 20 records would require this change.

Any help would be greatly appreciated.
0
Comment
Question by:davidlittle2008
2 Comments
 
LVL 18

Expert Comment

by:jmoss111
Comment Utility
Hi davidlittle2008,

If it were my db I would create another table with on the PK and the two changed columns.

Regards,

Jim
0
 
LVL 42

Accepted Solution

by:
dqmq earned 125 total points
Comment Utility
In DW parlance, your approach is called a type 3 changing dimension.  It's a perfectly valid solution if it meets your needs.  However, understand that it is limited to storing only the last change and you will not know who did it or when it was done.  Using another table provides a more robust audit history.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now