Analyse query relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with lots of saved queries, most of which are interelated.
Is there a way of ascertaining which queries use a particular query, so that
if I amend a query, I know which ones I need to check/amend to ensure that
are also working ok.

Many thanks
 
This is pretty basic, but may get you started:

SELECT MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects
ON MSysQueries.ObjectId = MSysObjects.Id
WHERE MSysQueries.Expression Like "*" & [qryName] & "*" GROUP BY
MSysObjects.Name;
 
Excellent - just what I needed!
Thanks

Allen Browne said:
This is pretty basic, but may get you started:

SELECT MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects
ON MSysQueries.ObjectId = MSysObjects.Id
WHERE MSysQueries.Expression Like "*" & [qryName] & "*" GROUP BY
MSysObjects.Name;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Eusi said:
I have a database with lots of saved queries, most of which are
interelated.
Is there a way of ascertaining which queries use a particular query, so
that
if I amend a query, I know which ones I need to check/amend to ensure that
are also working ok.

Many thanks
Click to expand...
Click to expand...
 
Back
Top