[AccessD] (Tip) Locate a Table Name within Queries

or better still, if there is a tendency to use subqueries:
 
PARAMETERS [Enter table name] Text ( 255 );
SELECT MSysObjects.Name, IIf(IsNull([Expression]),[Name1],[Name2] & "("
& [Expression] & ")") AS SourceTable
FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id =
MSysQueries.ObjectId
WHERE (((IIf(IsNull([Expression]),[Name1],[Name2] & "(" & [Expression] &
")")) Like "*" & [Enter table name] & "*") AND ((MSysObjects.Type)=5)
AND ((MSysQueries.Attribute)=5));

B
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030725/06e0c966/attachment-0001.html>