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 controls and reports are actually being used.
I can easily create a table and stick code on each control 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.