Solved

Best way to track data changes

Posted on 2008-10-25
2
197 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
ID: 22804417
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
ID: 22804800
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

820 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