A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tracking Log



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 10:19 PM posted to microsoft.public.access
PJ
external usenet poster
 
Posts: 265
Default Tracking Log


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!!
  #2  
Old May 18th, 2010, 12:41 AM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Tracking Log

On Mon, 17 May 2010 14:19:01 -0700, PJ wrote:


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

--

John W. Vinson [MVP]
  #3  
Old May 18th, 2010, 04:34 AM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Tracking Log

On Mon, 17 May 2010 17:41:28 -0600, John W. Vinson
wrote:

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



On Mon, 17 May 2010 14:19:01 -0700, PJ wrote:


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

  #4  
Old May 24th, 2010, 08:31 PM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Tracking Log

Tom van Stiphout wrote:

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/
  #5  
Old June 5th, 2010, 03:27 AM posted to microsoft.public.access
roccogrand
external usenet poster
 
Posts: 188
Default Tracking Log

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

"PJ" wrote:


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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.