How to tell which objects are being used in my application.

[ebs17]

ACCESS Dependency Checker by Thomas Koester

However, in the case of the problem mentioned above, I do not believe that the presence of queries per se is the cause.
You should broaden your view to include domain aggregate functions (DLookup, DMax, ...) that are used en masse in queries, forms and reports. You should also pay attention to recordsets that are opened and not explicitly closed.

At 13 MB, the front end is nowhere near large enough to be problematic simply because of the size of the number of database objects. You should rather focus on the respective programming.

 

[strive4peace]

thanks for the mention, @MajP

The most recent version of my Analyzer (free with source code) is here:

Analyzer

Analyzer for Microsoft Access

msaccessgurus.com

I also still have the 97 version of it

 

[gemma-the-husky]

I have a front end DB that is 13,040 KB in size. I can no longer make an ACCDE compiled version to distribution. I have emptied and bunch of irrelevant tables (linked) but have a ton of queries not being used that I would like to be able to delete but I need to know if there is a way to determine if each object is being used or not.
Can someone guide me in the correct direction.
Thanks

Do you mean 13Mb. I have DBs of 50mb with thousands of objects that build to accde with no problems. They won't build if they don't compile. Are you certain there's no code issues. Might you have code that works in both 32bit and 64bit access. That might run as a .dB, but won't compile to an .de, I don't think
.