Solved

Best way to track data changes

Posted on 2008-10-25
2
198 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
[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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

751 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