Reporting all code/queries that affect or use a particular table

[Kathryn]

Is it possible to track and report on any and all events,
code, queries, etc. that call, effect or include a
particular table?

As my app gets bigger, it is harder for me to keep track
and I end up making changes or additions which
inadvertently effect data and existing processes.

Any ideas you may have will be greatly appreciated!

Thanks,
Kathryn

 

[Larry Linson]

There are third-party tools that will search for every use of a string
(e.g., the name of the table) in your database. Two that I have used are
Speed Ferret, from Black Moshannon Systems, http://www.moshannon.com, and
Find & Replace, from Rick Fisher software, http://www.rickworld.com. There
may well be others.

Larry Linson
Microsoft Access MVP