Redundant queries

C

C Tate

If a database has hundreds of queries, is there a relatively quick/simple
way to find out if any of them are redundant?

Thanks in advance.
 
J

John Vinson

If a database has hundreds of queries, is there a relatively quick/simple
way to find out if any of them are redundant?

Thanks in advance.
Click to expand...

Not really. Rename each one and see what breaks...

Or, get "Total Access Analyzer" from http://www.fmsinc.com; it will
give you a detailed report on interdependencies. You can identify
queries which are not used anywhere else.
 
D

Darrell Childress

Access 2003 has a feature which will allow you to find "dependencies" on
queries and tables. It's a nice feature which should have included a
long time ago.
 
Top