Track Form/Query/Report usage

[Snak]

Hi

About 10 years ago I wrote an Access application which is still in use. Over the years certain parts have become superfluous and new parts have been added by a variety of users. Thankfully they have stuck to the original ideal and only used macros and queries - and not modules of badly written code.

However, the system is beginning to creak and I have been asked to rewrite the system from scratch with a shiny new interface, cutting the dead wood and incorporating those new features that did not have a half life of one report.

I would like to be able to monitor the use of the system in order to be able to determine just which tables, forms, queries & reports are being used. I'm not interested in auditing who added what to which table, so a 'normal' audit system is not required. Can anyone tell me how I would record which of the above are being used and how regularly?

I have asked the users and (of course) they don't know.

TIA

 

[thisisntwally]

just an idea, but could you build a table with a field for each report/form/whatever that you would like to monitor, and then tack a bit of code into each (maybe the onopenevent?) which would add 1 to the existing value?

 

[Snak]

Thank you

Hi - and thanks

I was working along the lines of that thanks to another thread and it seems that that is the way to go.

Thanks again

 

[The_Doc_Man]

You can track forms and reports easily enough through audit trails. Search this forum for Audit Trails.

You cannot directly track queries because no executable events are associated with them. Unless access to queries is controlled with a switchboard type of form, you cannot do this.