Where Used?

[ksmith]

Just wondering... Does anyone know of a way the get all of the reports and forms where a query is used? In affect a 'Where Used' utility.

KSmith

[Robeen]

Not sure if this will help - but it might get you started:
http://www.fmsinc.com/free/newtips/a...ccesstip21.asp

I Googled ms access dependencies.

All the best!

[ksmith]

Thanks that's what I'm looking for, I think..!

KSmith

[Robeen]

Lol . . .

I just looked at the dependencies for a couple of tables and queries in one of my databases.

Very useful.

If I ever want to go in there and clean up unused queries or tables . . . looking at the object dependencies would give me a good starting point to see if the object is used by another object downstream . . .

All the best!!