I recently inherited a large Access project developed over many years. I and all the users are running Office 365 on Win10 machines. In trying to get my arms around the database I dipped my toe into the world of Visual Basic Extensibility and was able to come up with a simple census: over 4,700 procedures with a total code line count of over 162,000! I suspect there are many procedures which are no longer used as this database has been in constant enhancement mode since its initial development in 1999. Using the VBIDE, I’ve been able to develop a rudimentary Call Tree to find procedures no long in use.
I can run the applications basic functionality, it is not password protected, with out any issues. However, if I try to run my new VBIDE code I get an error 50289 – project protected. I stumbled onto the fact if I put a break at the beginning of my VBIDE code I don’t get the error. Internet searching has not returning anything on point regarding this Access error and how to corrected it.
I hope someone can point me in the right direction.
Thanks very much