Access 2003 Find Calls to Macros
Posted on 2016-08-31
I've inherited some Access 2003 DB's that link to MSSQL DB's and the supposed developer versions of the Access DB's are simply copies of original Access DB's. Meaning that all the tables and such are still linking to production MSSQL DB's. I have gone in and made sure everything is pointing to a development DB in MSSQL. Now my only concern is locating any code that fires of a macro (that would touch the production DB's). I need to be certain that I have cut all ties to the production DB's.
I know that I can select Macros from Object list on left side and find macros there. However, I would like to easily locate all code references to the macros. There are too many Forms/Reports to skim through. The way I am currently doing it is using ctrl-F (Find: macro name) on Project. Will this guarantee that I catch all uses of a macro? Is there anything else that I am overlooking that could impact a production DB?