Log file

[ranen]

Hi! I really need help withi question as soon as possible. I do have a database, I want to log all the things inside my db. every time they save every time someone do somethng on the database i should log it. how will i do that...thank you for the help

 

[alastair69]

You may find this useful!

Link :http://allenbrowne.com/AppAudit.html

Alastair

 

[Bat17]

This will be a good place to start
http://www.access-programmers.co.uk/forums/showthread.php?t=44231&highlight=Audit+trail

Peter

 

[alastair69]

Another good website is http://www.mvps.org/access/resources/downloads.htm#H

The first listed item under "h" is history.
Alastair

 

[ranen]

Confuse

I studied all the forms aand the code you post but still confuse on how to de it. The reason is I am using many tbales in one form and I don't know how the code will save it to one table only. any way thanks for the response.

 

[ghudson]

You only have to add one field to each table [that you want to track changes to] if you use my Audit Trail method. Check out my sample at Audit Trail

 

[ranen]

log file

Hi. sorry to bother anyone i'm just wondering is it possible to save all the changes in one table? I really need this one but i'm not sure if what i want to do is possible. Thank you so much...