Re: Finding out who changed something

From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 03/01/05 

Date: Mon, 28 Feb 2005 21:48:03 -0800

Which code are you using exactly Jeff?
Normally the only requirement I ever need is to record who made a change
to a record (whatever that may be) and when. I normally do not need to
know what *exactly* someone has changed since that need has not arisen
yet. 

-- 
Jeff Conrad
Access Junkie
Bend, Oregon
"Jeff S" <Jeff S@discussions.microsoft.com> wrote in message
news:C5055FB3-04BE-4CAB-8E19-F074FACB6AED@microsoft.com...
> 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
Loading