Log File/ Audit File for MS Access Table

[GigglyGirl]

Hi,

I need help to find out if there is a way to keep track of changes in an Access table.
For example a history file that records the changes made and the date either in text file or any other file format.
I will appreciate your answer.

Thank you

 

[MichaelRed]

faq181-291

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[GigglyGirl]

Hi MicheaelRed,
Yeah I saw your code and I just wondering is that in the level of forms?? Because I don't want anyform. The thing is I just want to record the changes from tables.. Is that possible.
Like example.
Table name Field Name Change made date
XXX Number 55 to 44 Dec. 9,2002

and so on.

thanks

 

[MichaelRed]

I guess that if the faq is not satisfactory, I do not know how to help.


MichaelRed
m.red@att.net

Searching for employment in all the wrong places