Track user usage - help

[scotiwis]

Hi,


I have a series of large Access databases (hooked into SQL backend) that are used as primary ERP within an organization.
Thousands of forms and reports built up over 12 years.
I need to do a major tidy up job and find out which form objects and reports are actually being used.
I can easily create a table and stick code on each object on each form to record into the table userID, date, dbname, formname, objectname - but that's obviously a massive job to manually add this code to every single button/dropdown in the databases.
Is there something that can do all this automatically??

Many thanks to anyone who can help.

[goodguy]

Create a routine to save a list of all loaded forms and reports to a table say every 3 minutes. That should give you a very good picture of the most frequently used. I would also advise including queries in the checklist.

[alansidman]

Cross Post
http://www.access-programmers.co.uk/...d.php?t=216578
http://www.excelguru.ca/node/7

[orange]

Saw your post and discussed an approach at
http://www.access-programmers.co.uk/...d.php?t=216581

Good luck with your project