relationships for queries ?

[Patti]

Is there a way to find out which reports, forms and other
queries a particular query is related to? I have been
making lots of changes and cleaning up an existing
database. I've created some new queries that are more
efficient and know there are some I can eventually
delete, but don't want to yet without making sure they
aren't connected to any reports, etc. I could go through
each of the forms, reports, etc. one by one, but there
are quite a few.

tia,
Patti

 

[Guest]

I fairly confident MS Access does not catalog dependencies as you describe
them. There is the "Auto Correct" feature, but I believe this merely updates
field references in forms and reports when you change field names in the base
tables (I don't use this feature as it bloats the database).

Now, SQL Server does catalog dependencies. You can ask SQL Server to tell
you which views/queries depend on it, and it tells you what it depends on.
Even more, in SQL Server 2000, you can implement "schema binding," meaning
you can't change or delete objects if another object depends on it. For
example, if you schema bind a view/query to a table, then you can't
drop/delete the table.

I love Jet; I salivate over SQL Server.

David Atkins, MCP

 

[John Spencer (MVP)]

You might take a look at the following add-ins


Find and Replace http://www.rickworld.com (shareware/trial version)
Speed Ferret http://www.moshannon.com
Total Access Analyzer http://www.fmsinc.com