Redundant queries

  • Thread starter Thread starter C Tate
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top