Error 3706 occurring on 64-bit office

[donalde]

Hello

My collegues have a problem that has got me baffled. Both collegues have received new laptops with 64-bit office 365. Both need to run macro from workbook located on company's network drive. Previously all laptops (including my current one) have been 64-bit windows running 32-bit office 365. However, these new offices generate error 3706 provider not found when running macro. I have looked this error for few days with google, and all I get same instructions: install Microsoft Access Database Engine Redistributable 2010 and check VBA references. Colleagues have same references as I have and both have installed that x64 database engine.

Is there something wrong on my connection, and how to fix it?

    strFile = AccessPath + "accessfile.mdb"
 
    strCon = "Provider=Microsoft.Jet.OLEDB.12.0;Data Source=" & strFile
 
    Set cn = CreateObject("ADODB.Connection")
 
    cn.Open strCon

So error comes on that cn.open strcon part.

 

[RoryA]

It should be Microsoft.ACE.OLEDB.12.0

 

[donalde]

It should be Microsoft.ACE.OLEDB.12.0

Doh! what a mistake from my side... just shows how blind one is for self written code. Now it works, thank you.