track changes made to existing data

[dhsdhs]

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?

[Robby]

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.

[Nerseus]

Actually, if you're 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 you're storing THAT in a variable somewhere... right? :)

 

-Nerseus

[Robby]

Right on Nerseus, I forgot to consider the DataSet aspect, that's much easier, thanks.