tags:

views:

474

answers:

3
+2  A: 

Yes, in the Database window, right click on the object (form/report/etc) and select "Object Dependencies". If it doesn't show up any where, it probably isn't used.

Although that doesn't tell you if it is called in VBA code somewhere. However you can almost totally eliminate that possibility by doing a search for the object name when viewing the VBA and make sure that you have "Current Project" selected instead of "Current Module". It doesn't prevent some evil coder from string concatenating the object name together somewhere; but it's unlikely.

CodeSlave
That didn't work see my edit above.
John Nolan
It should be there, here's MS's page on how to get it back:http://support.microsoft.com/default.aspx?scid=kb;en-us;833219
CodeSlave
If it's a complied project, you won't be able to search the VBA code.
John Mo
Compiled or exported to an MDE. It's not an MDE, because in the screen shot, the Design View option is not greyed out. Besides that, I just tried viewing the dependencies on an MDE and it worked. Viewing the code it self didn't but I don't think that's the case here.
CodeSlave
A: 

Here's an article advertising a commercial product.

pro3carp3
I have my doubts that the product would work on a compiled project.
John Mo
What's the likelihood of someone wanting to know about unused items in an MDE for which they don't have the source MDB?
David-W-Fenton
A: 

Try SpeedFerret over anything from fms (it has add'l features that will probably be useful to you as a developer, and it supports .mde files).

A demo can be obtained here: http://www.moshannon.com/downloads.html

Other useful MSAccess utitlities: http://www.granite.ab.ca/access/thirdparty.htm