Object usage info

[Rob]

I'm looking for some info on how to determine when a
qruery was last used or when a table was last viewed or
updated in any way.
I've inherrited a large Access app and was hoping for an
easy way to determine what is no longer in use instead of
digging into all of the code and each individual macro.
Thanks in advance.
Rob

 

[Sandra Daigle]

There are some utilities you can use to build object crossreferences. Two I
like are:

Total Access Analyzer by FMS:
http://www.fmsinc.com/products/analyzer/index.html

Speed Ferret is available at http://www.moshannon.com/index.html

Find and Replace is available at http://www.rickworld.com/

All are good products, the first two are more expensive but IMO have more
features and are faster. Find and Replace is inexpensive and a bit slower in
operation on a large mdb. Both are downloadable and
available in demo or trial versions.