Acc: Connection Error when using CurrentProject.Connection or CurrentDB.Connection

Article ID: 2459087 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you open your database in Access you receive an error "Method 'Connection' of object '_Current Project' failed. This failure occurs when the VBA Application.CurrentProject.Connection or Application.CurrentDB.Connection is called.

Cause

The Access Database Engine/Access Connectivity Engine (ACE) is included with a number of products other than Microsoft Access such as Microsoft Visio and Microsoft Project. If you install a version of ACE that's different than that of Access, the ACEOLEDB.DLL path in the registry may not point to the corresponding ACE version.

Resolution

You should be able to resolve this issue by running a repair of the Office or Access installation.

Alternatively, you can modify the registry key changing the dll path to match that of your Access version.

Access 2007 should use OFFICE12, Access 2010 - OFFICE14 and Access 2013 - OFFICE15

 

(OS: 64bit Office: 64bit) or (OS: 32bit Office: 32bit)

Key: HKCR\CLSID\{3BE786A0-0366-4F5C-9434-25CF162E475E}\InprocServer32\

Value Name: (Default)

Value Data: C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

 

(OS: 64bit Office: 32bit)

Key: HKCR\Wow6432Node\CLSID\{3BE786A0-0366-4F5C-9434-25CF162E475E}\InprocServer32\

Value Name: (Default)

Value Data: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

 

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2459087 - Last Review: December 28, 2012 - Revision: 5.0
Applies to
  • Microsoft Office Access 2007
  • Microsoft Access 2010
  • Microsoft Access 2013
Keywords: 
KB2459087

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com