<div>
Can you post the whole code? &nbsp;
</div>


Visio-2010-Access-2007.jpg

<div>
Because it is the right answer, and posting the rest of the code would have done nothing to add to the troubleshooting.
</div>


Because it is the right answer, and posting the rest of the code would have done nothing to add to the troubleshooting.

<div>
<div class="content wysiwyg-content">
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. &nbsp;I am able to fix the issue when I repair the install of Office 2007. &nbsp;However, each time I load and run Visio, it configures itself as if it has never run before, then breaks my Access again. &nbsp;It fails when loading the switchboard at the line:<br />
<br />
Set con = Application.CurrentProject<wbr />.Connectio<wbr />n. &nbsp;<br />
<br />
The error I get is Run-time error '-2147418113 (8000ffff)': Method 'Connection' of object '_current Project' failed. &nbsp;<br />
<br />
I have converted the database to 2007 (accdb) from XP (mdb), but this is not helping. &nbsp;I can't even repair and compact the database, it throws the same error.<br />
Any help would be appreciated. &nbsp;
</div>
</div>


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.  

Installed Visio 2010 now Access 2007 won't load switchboard

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.