Find every instance a field or table is used.
Posted on 2011-09-29
I have an Access database that connects to a SQL server. We are doing a ton of rewrites because of our external systems that have changed and they feed into this ordering database.
Is there a utility that will into an access database and tell you EVERYWHERE you used a field or table?
For example, I want to unlink a Table SSTAR_Orders. I want something to tell me every form, query, report, module, VB code etc that used it so that I can redirect it somewhere else. Others I don't want to redirect, but just remove, so just need to go clean them up.
Is this possible??