Audit Trail for Non Autonumber table

[Lordlentz]

I would like to create an audit trail in Access 2003. However, the table I
wish to audit does not have an autonumber primary key. Is there an
alternative auditing method that will allow a number format as the primary
key?

 

[aaron.kempf]

every table should have an autonumber and every autonumber should be a
primary key

sorry dude; your plain text keys are goddamn ridiculous

 

[Allen Browne]

The code in this page should work with any table that has a primary key
field of type Number, size Long Integer:
http://allenbrowne.com/AppAudit.html

If you want to work with other kinds of fields, you can adapt the approach
(i.e. modify the code.)

 

[aaron.kempf]

long integer?

are you friggin kidding me?

do people in the real world really still use MDB?

ROFLMAO