Database Log

[CCIDBMNG]

I was wondering if Access keeps track of any changes made to a database. I'm having problems with a database that someone before me created. Some how records are magically disappearing from tables and a field in certain records in another table are magically being changed. So I'm wondering if access somehow keeps track of when a table or form is opened. If not does anyone know how to go about doing something like this? I know I can manually create code for each form to track who's going in and out. But is there some way to track when a table is opened and if things were updated, deleted or added. Any help would greatly be appreciated. I need to prove that Access itself is not doing these crazy things on it's own.

Thanks.

 

[ghudson]

Access does not do what you want. You would have to program the db to do that and that would take a lot of work.

You could add an Audit Trail function to record who, when and what is modified in a table but that will only work if the users do it from within a form that is bound to a table. There is no way to track record changes made directly from within a table. You would have to use Access secutiry to limit which objects a user can access and what they can do with the data from within each object.

In short, the db is doing what it is programmed to do. The users who have direct access to a table can do what ever they want and without leaving a trace. That is one of the many reasons that users should not have direct access to the tables and also to the design of any db objects.

Here is a link to an Audit Trail sample I posted.