Re: adoquery/stored procedure - original and modified values?

See if this helps...

http://www.skzimmelman.com/Articles/TFields_WhatChanged.htm

-Steve-

"P.S.Bell" <pat@xxxxxxxxxxxxx> wrote in message
news:VA.00000493.00d5f87d@xxxxxxxxxxxxxxxx
I have to determine which actual data has changed in modified
ado dataset records (query and stored procedure). I check for
'global' record changes if state=dsEdit. But I need to provide
an audit trail of what has changed. Ideally I would like to
compare original values to modified values for each field by
number and then access the field name if a difference is found.

Pat Bell



.

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: Finding out who changed something
    ... just a single field rather than all fields in the record. ... "Jeff Conrad" wrote: ... How to Create an Audit Trail of Record Changes in a Form ... How to Create an Audit Trail of Record Changes in a Form ...
    (microsoft.public.access.security)
  • 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)