MS Access, tracking data and other changes?

[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)

 

[Joan Wild]

Allen Browne has a sample at his site

Creating an Audit Log
http://www.allenbrowne.com/AppAudit.html

 

[Guest]

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

 

[Joan Wild]

I would guess it's related to the references you have set - see the other
thread.

 

[Guest]

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?

 

[Guest]

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?