Dec 03

Finding Unused Objects and Code in Microsoft Access

If you're like most Microsoft Access users and developers, you've created databases with lots of objects. Over time, it's easy to lose track of which objects are still needed. A temporary query or report becomes permanent because you're not sure if it's being used by other objects. Same with macros and VBA code.  The annoying thing is that you may waste time maintaining objects and code that's not even being used. I've written a detailed article about the challenges of finding unused objects (you have to first determine where all objects are referenced before identifying unused ones) and one of the main benefits of using Total Access Analyzer.