Prev: Appending records
Next: Updating Table with a form
From: PJ on 17 May 2010 17:19

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!!
From: John W. Vinson on 17 May 2010 19:41
On Mon, 17 May 2010 14:19:01 -0700, PJ <PJ(a)discussions.microsoft.com> 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]
From: Tom van Stiphout on 17 May 2010 23:34
On Mon, 17 May 2010 17:41:28 -0600, John W. Vinson
<jvinson(a)STOP_SPAM.WysardOfInfo.com> 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 <PJ(a)discussions.microsoft.com> 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
From: Tony Toews [MVP] on 24 May 2010 15:31
Tom van Stiphout <tom7744.no.spam(a)cox.net> 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/
From: roccogrand on 4 Jun 2010 22:27
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!!
 | 
Pages: 1
Prev: Appending records
Next: Updating Table with a form