Confused about user information tracking

[accessinformation]

I am really confused after reading some books and net stuff on security, etc. I am working on a database and the company really wants to be able to track user information when a user makes changes.

Would this be tracked specifically in the table on which the change was made i.e., I would need code for each table? Is there anywhere that addresses this specifically? I found a lot on security and user groups, etc. but haven't stumbled onto how to monitor transactions of sorts by user ID.

Thank you for any help or direction.

 

[SkipVought]

Hi,

Could be just one table for transaction logging, that would include fileds for the TableID, UserID, TransType, DateTimeStamp at a minimum.

You might want to post this question in one of the Access forums or Forum669.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[accessinformation]

thank you skip for the information and for direction where to post i didnt know where exactly this should go thanks again