Suggestions for creating a set of audit trail tables in database

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm going to ask here, since I'm using ADO, but this really is quite a
general question:

I want to create a sequence of audit tables within my Access database
(so I can prove what the user altered and when).

Amended data is associated with a start and end date - its possible
that the user may specify overlapping dates if they entered a wrong
date, so the date sequence is not necessarily contiguous.

In addition, I don't want to end up with hundreds of ancient audit
tables. Ideally, they will be deleted if they are over a year old.

My first thought is to give the tables names which incorporate the
associated dates, eg

Audit20070101to20070130
Audit20070101to20070131

but that does seem a bit longwinded. The other option seems to be to
create a straight sequential number, and to save the dates within the
table, eg

Audit07 <--- contains Start Date 01/01/2007, End Date 30/01/2007
Audit08 <--- contains Start Date 01/01/2007, End Date 31/01/2007

Does anyone have a better idea? I want to make it easy for a
technician to review the tables in Access and know what they are
looking at, while also (hopefully) making it easy to decide when a
table is over a year old and can be deleted.

Many thanks for your input...

.

Relevant Pages

  • Logon XP prof.: username and password grayed out
    ... security processes, permissions and audit the time ... sequence from a setting of eight hours to ...
    (microsoft.public.windowsxp.security_admin)
  • Automatically Assign a Number Reference
    ... I am converting a paper based audit program to an Access database and need ... c.1 for the first cash procedure, c.2 for the second cash procedure, ... automatically assign this sequence to each new record. ...
    (microsoft.public.access.forms)
  • Re: Automatically Assign a Number Reference
    ... What I would suggest is to setup a table with 2 numeric fields. ... would hold the next sequential number for the cash entries and the other ... >I am converting a paper based audit program to an Access database and need ... > automatically assign this sequence to each new record. ...
    (microsoft.public.access.forms)
  • Re: Primary Key Autonumbers
    ... But the concept of thousands of Access database users who all can ... enough to explain that ANs are not guaranteed to be sequential. ... Access databases that were peppered all over with visible AutoNumbers. ... sequence. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: date in database compare with the current date
    ... (I am out of sequence, ... message when a date in Access database is going to expired soon ... and is that possible to achieve that using Microsoft script editor? ...
    (microsoft.public.access.formscoding)