Tracking changes

T

Tara

I would like to be able to track record changes by capturing the date and
time of change, the RecordID of the record that was changed, the name of the
field in which data was changed, the UserID of the person logged in at the
time, and the name of the table that contains the changed record. I had
originally planned on only doing this for one table, in which case I would’ve
simply used an append query in the AfterUpdate event. But I’ve now been
asked to do this for several tables, so obviously an update query isn’t the
way to go since the tables will vary. Unfortunately, I have no idea how to
approach this via code, so I really need some help. I’m already tracking the
UserID and their time In/Out of the database, if that makes any difference…
 
P

Paul Shapiro

You might also consider whether SQL Server is a better fit to your needs.
SQL 2008 includes change tracking features which might make this task a lot
easier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unclear change tracking process 0
Dynamic Naming of Form Button 3
Display Number of Employees 4
Run-time Error 5 "Invalid Procedure Call or Argument" 1
Copy previous record into form field 0
sqlite-odbc write conflict 2
Add 31 records w/ consecutive dates w/ command button? 2
Problem Moving to New Records 1

Top