Tracking changes made to data in tables

[Guest]

Ok I really need help this is my 4th post and it doesn't appear to have
gotten any feedback and I see individuals who have posted after me show up.
I hope this is simple enough I tried to implement the Security wizard but
that does help because it doesn't work on an action query that has been
saved. I want to know how can I track when records are deleted and by who, I
believe I may have to setup security witht he wizard anyway which is fine but
will it help me to track when data is delete or change in any table and by
who. PLEASE HELP.......

 

[Guest]

http://www.mvps.org/access/modules/mdl0021.htm

To track anything that anyone can do to in a database, you need one that has
auditing built into it such as Oracle. Even then turning on full auditing can
really drag down performance.

 

[Guest]

I'm affraid you must track changes programatically.
I remember old DOS relational database called PC FAND with Journal function;
it was as easy as ABC:

1) declare file (table)
2) declare journal file; the full declaration: JournalOf SomeFile
3) edit(Table,..., journal=JournalFile)

Not sure if there's something like that in Access... :-/

Vlado

 

[Guest]

I used http://www.allenbrowne.com/AppAudit.html and found it great for my
needs. It provides audit trails on all transactions for a selected table.
Maybe it will provide resolution.