Does Access 2000 have an audit trail feature?

G

Guest

and if not how would I set one up...

Every table on my DB has fields for last edit user and last edit date which
are updated automatically via code in the form when a user makes a change -
this gives me at least a record of who changed the record last but it doesnt
show me exactly what they changed and it doesnt give me an ongoing historical
record.

I'm considering setting up a second (initially empty) copy of my DB and
copying existing records into it before they are changed. This seems like a
rather cumbersome method and potentially something of a disc-space hog.

Does anyone have any brighter ideas?

Thanks

Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top