In Access DB, where are tables referenced?

[ssissons]

I haven't seen this, but I'll bet it's on the forum somewhere.



Is there a way, in Access ??-2013, to search for all the locations(Forms, Queries, Macros, etc.) a table is referenced?

Thanks
Scott

[June7]

Could try setting the Navigation pane to Tables and Related Views. It won't show macros and VBA procedures.

The Database Documenter might show this info but it uses a lot of paper and is hard to read. Again, not macros and VBA.

Otherwise, get an add-in (unless you want to write a LOT of VBA code). I use Rick Fisher's Find and Replace - cost about $50. Another that has good reviews is VTools freebie.

[ssissons]

Thank you. I'll try those.

[ItsMe]

Under Database Tools you can use the Object Dependencies tool. It is not going to list everything out for you. You will need to analyze one object at a time. Also, it will not help you understand whether or not an object was referenced in a Module. I have seen some code examples that check for stuff like that. Probably easier to use an add-in, like June7 mentioned, though.

[June7]

Ooh! I forgot about that tool. However, again doesn't show macros and VBA.

And Rick Fisher's F&R will report exactly where the reference is in the other objects as well as macros and VBA modules.