Determining which Queries use which Queries or Tables as Input

[wcrimi]

My database has gotten to the point where there are about 30 tables, 100 Queries, 10 macros, 20 appends, and a few reports.

It's so large now that sometimes I can't remember which queries use which tables and other queries as input. I have to go back into the queries themselves and refresh my memory. That brings up a small dilemma for me now. I'd like to change the name of a couple of tables and queries because the original names are less meaningful now than when they were originally created. In fact, the current name is misleading. I know that can get very tricky and cause problems. So I want to be extra careful about it and make sure I don't miss anything or destroy any linkages.

Let's say I have a table called "Late Ratings" and I want to change the name to "Track Profile", is there any way I can quickly determine every query that uses that table so I don't miss anything?

Similar with queries.

I have a couple of queries that perform general functions that are used by many other queries. Is there any way I can quickly determine every query that uses that query so I don't miss anything?

Thanks

[CJ_London]

you can use the object dependencies feature in Access (under the database tools tab) - although this will not capture references to the table in your code (don't know about macros, don't use them). For code if you open the vba editor, you can search for the table name to see if it is used anywhere

[Micron]

Did you consider using the database documenter for the queries only? You'd get a printout of the sql statement along with a bunch of query properties.
Someone else posted here a while ago, trying to put query dependencies into a table, which would require a lot of code. It still had certain limitations as well.
PS: you really have spaces in your proposed table names?

[wcrimi]

PS: you really have spaces in your proposed table names?

When I started, I knew almost nothing. I was self educating on the fly. So many of my initial table and query names have spaces. The new ones do not.

[orange]

You can run this query as a start (found via Google)

SELECT o.Id
, o.Name
, o1.Name AS [References]
, o1.Type AS TypeOf
FROM MSysObjects AS o1 RIGHT JOIN
 (MSysQueries AS q INNER JOIN MSysObjects AS o ON q.ObjectId = o.Id) ON o1.Name = q.Name1
WHERE (((o.Type)=5) AND ((o.Flags)<>3) AND ((o1.Type) Is Not Null));

For reference of typeof in result

'typeOf = 1 ...Table
'typeOf = 5 ...Query
'typeOf = -32768 ...Form
'typeOf = -32764 ...Report
'typeOf = -32761 ...module
'typeOf = -32766 ...macro

[pbaldy]

Search for a free utility called V Tools, which had a deep search function.