Show linked forms and reports for querries

[Guest]

I created a database as I was learning Access and have duplicated querries
and steps now that I am more familiar with certain features. Is there a way
to show what forms and reports are linked to a particular querry so that I
can delete unnecessary querries and simplify my overall database?

 

[Roger Carlson]

There is a product called Total Access Analyser by FMS Inc. that will do
that.

However, I usually just rename a query (or table or form) that I believe is
obsolete with a xxx prefix. If I discover that I need it again, I can
rename it back. After using the database a while, I find I still don't need
it, I delete it.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L