Prev: How to add leading zeros to split field string
Next: using 'bold' in a continuous form
From: Tara on 8 Apr 2010 16:36
I would like to be able to track record changes by capturing the date and
time of change, the RecordID of the record that was changed, the name of the
field in which data was changed, the UserID of the person logged in at the
time, and the name of the table that contains the changed record. I had
originally planned on only doing this for one table, in which case I would've
simply used an append query in the AfterUpdate event. But I've now been
asked to do this for several tables, so obviously an update query isn't the
way to go since the tables will vary. Unfortunately, I have no idea how to
approach this via code, so I really need some help. I'm already tracking the
UserID and their time In/Out of the database, if that makes any difference…




From: Barry A&P on 8 Apr 2010 19:31
Search for "Audit log" or check out allen brownes great link on the subject
http://allenbrowne.com/AppAudit.html

Barry

"Tara" wrote:

> I would like to be able to track record changes by capturing the date and
> time of change, the RecordID of the record that was changed, the name of the
> field in which data was changed, the UserID of the person logged in at the
> time, and the name of the table that contains the changed record. I had
> originally planned on only doing this for one table, in which case I would've
> simply used an append query in the AfterUpdate event. But I've now been
> asked to do this for several tables, so obviously an update query isn't the
> way to go since the tables will vary. Unfortunately, I have no idea how to
> approach this via code, so I really need some help. I'm already tracking the
> UserID and their time In/Out of the database, if that makes any difference…
>
>
>
>
From: Paul Shapiro on 8 Apr 2010 20:51
You might also consider whether SQL Server is a better fit to your needs.
SQL 2008 includes change tracking features which might make this task a lot
easier.

"Barry A&P" <BarryAP(a)discussions.microsoft.com> wrote in message
news:0D196D82-E995-4B4A-818C-04775789E593(a)microsoft.com...
> Search for "Audit log" or check out allen brownes great link on the
> subject
> http://allenbrowne.com/AppAudit.html
>
> Barry
>
> "Tara" wrote:
>
>> I would like to be able to track record changes by capturing the date and
>> time of change, the RecordID of the record that was changed, the name of
>> the
>> field in which data was changed, the UserID of the person logged in at
>> the
>> time, and the name of the table that contains the changed record. I had
>> originally planned on only doing this for one table, in which case I
>> would've
>> simply used an append query in the AfterUpdate event. But I've now been
>> asked to do this for several tables, so obviously an update query isn't
>> the
>> way to go since the tables will vary. Unfortunately, I have no idea how
>> to
>> approach this via code, so I really need some help. I'm already tracking
>> the
>> UserID and their time In/Out of the database, if that makes any
>> difference…

 | 
Pages: 1
Prev: How to add leading zeros to split field string
Next: using 'bold' in a continuous form