LOG FILE

[Guest]

Hi
I have done a logfile telling which a user modify tables data. But this
working only in tables that have as primary key an Autonumber field!! Is
there anyway that I can do that and in Tables that have a primary key but is
not Autonumber??
Just note that my database is already finished with data in it so is not
easy to change the primary keys
Please give me a soloution

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "AuditTrail.mdb" which illustrates how to create a log file.
It uses autonumber fields, but there's no reason it shouldn't work with
natural keys. Perhaps if you compared it to your program, you might get
some ideas where it's going wrong.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L