Tracking changes made to data in tables

J

Julius

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.......
 
V

Vladimír Cvajniga

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
 
Top