ActiveX component can't create object

[jkp]

I have a vba program that uses a Jet database (DAO36.dll). It works fine on 2013 and 2014. We just installed 2015 and find that it will not work with this version. This is the code causing the issue:

   ' Open Microsoft Jet Database object.
    Set wrkJet = CreateWorkspace("JKP", "Admin", "", dbUseJet)

Any ideas why this works in the other versions, but not 2015?

[BlackBox]

I have a vba program that uses a Jet database (DAO36.dll). It works fine on 2013 and 2014. We just installed 2015 and find that it will not work with this version. This is the code causing the issue:

   ' Open Microsoft Jet Database object.
    Set wrkJet = CreateWorkspace("JKP", "Admin", "", dbUseJet)

Any ideas why this works in the other versions, but not 2015?

Welcome to AUGI.

You'll forgive my question, as I only code in LISP & .NET (skipped VBA altogether), but are you by chance simply missing a reference in your 2015 project?

[Ed Jobe]

My guess is that 2015 is 64bit and Office is 32bit. You won't be able to create a COM component under those conditions.

[BlackBox]

My guess is that 2015 is 64bit and Office is 32bit. You won't be able to create a COM component under those conditions.

That's true; I hadn't thought of that, given they worked with 2014, I (incorrectly?) assumed they were in x64 already.

Also, Office... At least for ProPlus 2013, and ProPlus 365 used here... Both x86 and x64 versions are available.

Cheers