Audit Trail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a programing begginer and try to write codes for audit trail. It can
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.

I will appreciate anyone who will give me a hand.

Best regards,

sc
 
Here are some links on this subject which should 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

There are many ways to create an audit trail of changes to records,
depending on what kind of info you want in the audit trail, whether you want
to maintain it in the same table or in a separate table, etc. For another
look at this subject, here is a link to an excellent article by MVP Allen
Browne:

http://allenbrowne.com.au/AppAudit.html
 
If you don't need to capture specific MOD's (ie client name changed from
Bill to John), I would add a STATUS field and use two values in it
ACTIVE and DELETED (active being the default). Then setup your DB so
that users don't have access to the underlying tables and are locked out
from actually deleting the record. To provide them with the ability to
'DELETE' a record, give them a button that updates the value to
'DETELED'. Of course, you'll want to have all of your FORMS & REPORTS
select records where the STATUS is ACTIVE. I would also add a LAST
MODIFIED field to capture the date/time & user how last mod the record.
This is somewhat easier in that you merely need to put a bound field on
the form and then use the FORM_beforeUpdate event to set the value to
NOW or whatever information that you want to capture.

David H
 
Back
Top