Tracking Log

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

 

[John W. Vinson]

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!!

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

 

[Tom van Stiphout]

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

 

[Tony Toews [MVP]]

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

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/

 

[roccogrand]

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