Auditing activity

[TimE]

Before everyone starts blasting me for posting ANOTHER audit question....

Is it possible to audit the activity at the "Database Window"? I have not locked the users out yet and someone deleted a table (I know, please don't rub it in). It would be nice to see who (I have the current user code) deleted or even created a table, form or query. Any constructive thoughts?

 

[KenHigg]

Can you convert it to an mde file so that they can't get to it? Or maben just hide the database window on start up?

 

[The_Doc_Man]

After the fact, you are screwed. But I'll be gentle.

This is why you build a switchboard form and only let folks see things controlled by the switchboards.

The problem with database window auditing is that there are no events in that context, so you cannot track anything at that layer. You can track items only in forms, reports, and macros. All of which can run VBA invisibly to do whatever auditing you need. Windows, tables, and queries do not allow for events, so no auditing is possible. UNLESS you have an Access FE and the BE is something else - like SQL Server, ORACLE, or something else that has code triggers.