Unused Subs and Functions

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Unused Subs and Functions

Post by Pat »

Is there a way to find unused Subs and Functions in an Access 2003/2007 database?
Last edited by HansV on 15 Mar 2011, 07:41, edited 1 time in total.
Reason: Ununsed > Unused

User avatar
HansV
Administrator
Posts: 78654
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Ununsed Subs and Functions

Post by HansV »

Total Access Analyzer from FMS Inc. claims to be able to do this - see Finding and Deleting Unused Objects and Code in Microsoft Access Databases including Tables, Queries, Forms, Reports, Macros, Modules, Procedures and Variables. It's expensive and I don't have experience with it myself.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Unused Subs and Functions

Post by Pat »

Thanks Hans, i ha found that site, in fact i have a question in for them re which module of theirs to use and how much is it.