MS Access, tracking data and other changes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have several users making changes... as simple as entering new names in a
list or updating old ones. There are, occasionally, serious error made. Is
there a way to track changes and who(user) did them? a transaction log
facility or some such?

please post and email me at (e-mail address removed)
 
Any Ideas, I've used Allen's audit log and followed the instructions exactly,
however when I make any changes on the forms, instead of tracking changes I
get a "syntax error on "From Clause" and when I debug, I get the following
highlighted: db.Execute sSQL, dbFailOnError
 
I changed the reference per your other note but the error still comes up, the
name of the ID it points to is correct, I'm at a loss. Is there another way
I might be able to track who makes changes?
 
I made the change per your other note but I'm still getting the same error,
the ID in the code for the two tables is correct. Is there another way to
track who is making changes?
 
Back
Top