Monitoring of Groups/Users modifications

[khtfc24]

Hi Everyone!
I'm having trouble tyring to apply a type of monitoring system that records when a user enters a database table, query, report, etc. and the details as to what they modified (added, deleted, changed,created...). I have looked through the copy of Microsoft Access 2003 that I own, as well as searched on Google for any information relating to this but found nothing. I really hope I have just not overlooked something, but if someone could help me out that would be great!
Thanks a lot.
K

 

[The_Doc_Man]

Good news/bad news.

If your users have direct contact with the database window, you are going to never ever be able to track everything they can do.

If you take SOME control over matters, you have hopes of tracking your DB changes. But... you won't be happy with what little you can do.

To fnd out what you CAN do, search the forum for topic AUDIT TRAIL

The reason you cannot always tell what happened on a given database entity is that if the change occurred in a context where no Access events can be triggered, you won't be able to capture any data through event code. And unfortunately, Access does, indeed, have some situations where no events can be triggered to do any data capture.

Big-scale databases such as SQL Server and ORACLE can track things more intimately because they have different event schemes. But things can fall through the cracks for those packages as well. Therefore, before you start any work on the subject, do the search I suggested.

 

[khtfc24]

Thanks alot The_Doc_Man for your advice! Hopefully I will find something
K