Code to determine where a table is in use

[markjkubicki]

Is the code that can be written to determine where a table is in use?
( ie: what forms, queries, etc are using a table )

Many thanks in advance,
Mark

[June7]

Probably, sounds very complicated. Why is this needed?

[Perceptus]

You could loop through all the querydefs and then do the forms using something from the below, just looking for the recordsource instead.

http://bytes.com/topic/access/answers/211017-looping-through-forms-then-controls