track changes made to existing data

D

dhsdhs

Member
Joined
Mar 6, 2003
Messages
6
Location
Maine
Is there someway to track changes made to data in a MS Access database?

Like someone changes a phone number in a record on a form -Is there a way to find out what changes were made to what fields for what records and when they were changed and what the record looked like before the change? And also record the logged in user that made the change?
 
You will need to track the changes yourself.
When the user enters a cell in the Datagrid, keep all the info for that row in a variable or array, then if they actualy make a change, you can write to a Log file or table.
If you are using text boxes, the just hold the Before data in a varible as they get focus.
 
Actually, if youre bound to a DataSet, the DataSet contains the original values as well as the current ones. Maybe that will work for you?

As for the logged in user, I hope youre storing THAT in a variable somewhere... right? :)

-Nerseus
 
Back
Top