Tracking Log

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

Hi,

What is the best way to have a tracking log? My understanding you can not
have one on a specific record set. Is that correct?? The user would like to
the ability to see who changed a record, keyed in transaction or deleted a
transaction in a form.

thank you in advance!!
 
Hi,

What is the best way to have a tracking log? My understanding you can not
have one on a specific record set. Is that correct?? The user would like to
the ability to see who changed a record, keyed in transaction or deleted a
transaction in a form.

thank you in advance!!
Click to expand...

Up until Access 2010 Access didn't have table level triggers that would let
you do this in all cases; if you can ensure that the user can ONLY use a Form
for managing data (not bypassing it and using tables or queries directly) you
can run an audit trail, with some VBA code. See

http://allenbrowne.com/AppAudit.html
 
On Mon, 17 May 2010 17:41:28 -0600, John W. Vinson

A2010 "standard" databases don't have triggers either, only sharepoint
("web") databases. And of course SQL Server supports triggers as well.

-Tom.
Microsoft Access MVP
 
Tom van Stiphout said:
A2010 "standard" databases don't have triggers either, only sharepoint
("web") databases. And of course SQL Server supports triggers as well.
Click to expand...

SQL Server would support the logging functions too I suspect. But
that's likely out of the scope of the original posters environment.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
PJ,

There are step-by-step instructions for creating an audit trail in the
"Access Cookbook." I succeeded in using them with Access 2003 but don't know
if the technique works with A2007 and A2010.

HTH

David
 
Back
Top