Installed Visio 2010 now Access 2007 won't load switchboard
Posted on 2011-02-18
I have recently installed Visio 2010 on my computer, and it seems to have broken the MDAC components for Access 2007 installed with Office 2007 Professional Plus. I am able to fix the issue when I repair the install of Office 2007. However, each time I load and run Visio, it configures itself as if it has never run before, then breaks my Access again. It fails when loading the switchboard at the line:
Set con = Application.CurrentProject.Connection.
The error I get is Run-time error '-2147418113 (8000ffff)': Method 'Connection' of object '_current Project' failed.
I have converted the database to 2007 (accdb) from XP (mdb), but this is not helping. I can't even repair and compact the database, it throws the same error.
Any help would be appreciated.