|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
MS Access, tracking data and other changes?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 aash***@mbay.net Allen Browne has a sample at his site
Creating an Audit Log http://www.allenbrowne.com/AppAudit.html -- Show quoteHide quoteJoan Wild Microsoft Access MVP Anne Ashley wrote: > 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 aash***@mbay.net 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 -- Show quoteHide quoteLori A. Pong "Joan Wild" wrote: > Allen Browne has a sample at his site > > Creating an Audit Log > http://www.allenbrowne.com/AppAudit.html > > -- > Joan Wild > Microsoft Access MVP > > Anne Ashley wrote: > > 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 aash***@mbay.net > > > I would guess it's related to the references you have set - see the other
thread. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Lori wrote: > 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 > -- > Lori A. Pong > > > "Joan Wild" wrote: > >> Allen Browne has a sample at his site >> >> Creating an Audit Log >> http://www.allenbrowne.com/AppAudit.html >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Anne Ashley wrote: >>> 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 aash***@mbay.net 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? -- Show quoteHide quoteLori A. Pong "Joan Wild" wrote: > I would guess it's related to the references you have set - see the other > thread. > > -- > Joan Wild > Microsoft Access MVP > > Lori wrote: > > 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 > > -- > > Lori A. Pong > > > > > > "Joan Wild" wrote: > > > >> Allen Browne has a sample at his site > >> > >> Creating an Audit Log > >> http://www.allenbrowne.com/AppAudit.html > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Anne Ashley wrote: > >>> 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 aash***@mbay.net > > > 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? -- Show quoteHide quoteLori A. Pong "Joan Wild" wrote: > I would guess it's related to the references you have set - see the other > thread. > > -- > Joan Wild > Microsoft Access MVP > > Lori wrote: > > 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 > > -- > > Lori A. Pong > > > > > > "Joan Wild" wrote: > > > >> Allen Browne has a sample at his site > >> > >> Creating an Audit Log > >> http://www.allenbrowne.com/AppAudit.html > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Anne Ashley wrote: > >>> 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 aash***@mbay.net > > > 
Other interesting topics
|
|||||||||||||||||||||||
