Re: Finding out who changed something

From: Jeff S (S_at_discussions.microsoft.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 15:19:02 -0800

I followed the links you provided and was able to make this work...almost.
This works in a stand alone form, but returns an error when the records are
edited from a subform.

I use a combo box to select the record to view in the subform and receive
the following: "Error #: 2448. Description: You can’t assign a value to this
object.”

This solution is actually overkill for what I was to do, but I thought if I
could make it work I could modify it to suit my needs. I was trying to audit
just a single field rather than all fields in the record.

"Jeff Conrad" wrote:

> "stag246" <stag246@discussions.microsoft.com> wrote in message
> news:E9CB19DE-D927-466C-87CB-CA65895386F1@microsoft.com...
>
> > If i set up the users/passwords/and groups up is there a way to see who
> > changed something like a table and when they did change it?
>
> It all depends on how sophisticated you want to get, but yes, it is possible
> to see record changes. Actually changing a table property? Probably not.
> See if these links help:
>
> Access 97: How to Create an Audit Trail of Record Changes in a Form
> http://support.microsoft.com/?id=183792
>
> Access 2000: How to Create an Audit Trail of Record Changes in a Form
> http://support.microsoft.com/?id=197592
>
> Here is a link to an excellent article by MVP Allen Browne:
>
> http://members.iinet.net.au/~allenbrowne/AppAudit.html
>
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
>
>
>

Relevant Pages

  • Re: Table History for Newbie
    ... How to Create an Audit Trail of Record Changes in a Form ... >> I would like when a User Modifys the above table, ... >> the Primary User for this to have a history, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Audit Trail
    ... How to Create an Audit Trail of Record Changes in a Form ... > keep track of the records the user modify and deleted with the date and name ... > of the users and the info of the modified or deleted record. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Table History for Newbie
    ... How to Create an Audit Trail of Record Changes in a Form ... > I would like when a User Modifys the above table, for example the INumber or> the Primary User for this to have a history, for example the phone is given> to J.Bloggs, but i want to know who previosly had it? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Finding out who changed something
    ... See if these links help: ... How to Create an Audit Trail of Record Changes in a Form ... How to Create an Audit Trail of Record Changes in a Form ... Jeff Conrad ...
    (microsoft.public.access.security)
Loading