MS Access 2007: Crashes on CurrentProject.Connection after MS Project 2010 Install
Posted on 2011-09-26
We have Office 2007 Installed and a sizable database with many VBA references to the CurrentProject.Connection method.
After installing an Office 2010 application such as Project or Visio, the Access 12.0 reference is replaced by the Access 14.0 reference. At this point, our Access 2007 database crashes without an error code everytime the code reaches a CurrentProject.Connection command.
I have tried decompiling, recompiling, and compact and repair to no avail. I am also afraid this will be a problem when we start updating individual clients to Access 2010. Our database needs to be able to run in a mixed environment. What needs to be done, and what is the easiest solution to implement? Is there a different reference that is needed for the Access 14.0 library?