Excel 2007 32 bits excel userform to Excel 2013 64 bits

[sebastienkanj]

I have built an application on excel to add and modify data on access (I used microsoft office 2007 31 bits version) everything works great!
I tried the application in another computer that has microsoft office 2013 64 bits version and it seems to have problem with the DAO reference!

When I run the application it put me "error 429" " object creation threw activeX component not possible "
The error comes on this line (the second line):

Please Login or Register  to view this content.

I heard maybe the reference of DAO is not supported in access 2013 application !

And also when I use this code (because I open a pdf file fril the userform so I use an API)

Please Login or Register  to view this content.

The application tells me "The code in this project must be updated for use on 64-bit systems" and put something named Ptr (I don't know at all what this is!!)

Can anyone help me?
Thank you !!

[Leith Ross]

Hello sebastienkanj,

The DAO library is 32 bit and is not supported on 64 bit Windows platforms. Here is the Shell Execute code with the needed changes.

Please Login or Register  to view this content.

[sebastienkanj]

Thank you for the shell execute!
What about the DAO reference? is there anyway to check another similar reference that works with 64 bits version without changing the vba code?

[Leith Ross]

Hello sebastienkanj,

From what I have read, Microsoft has not released a 64 bit version of the DAO nor does it plan to. Not being an Access expert, I don't know of any workarounds for this issue. You may want to post your question to an Access forum. You will probably get better and quicker answers.

[romperstomper]

The "Microsoft Office 15.0 Access Database Engine Objects" library is the DAO library for Office 2013 and is 64bit compatible. DAO 3.6 is not though.

[sebastienkanj]

I tried to check this reference but it still give me the same error!! Do i have to check it on excel or on access? Or both?

[romperstomper]

In Excel. I have tested it with both .accdb and .mdb files and it ran without error.

[sebastienkanj]

It's working! I unchecked the 3.6 object library reference and checked the 15.0 Access Database Engine Objects ! I had the ADO checked I unchecked it too and it works!! thank you very much for your help!

[sebastienkanj]

Hello sebastienkanj,

The DAO library is 32 bit and is not supported on 64 bit Windows platforms. Here is the Shell Execute code with the needed changes.

Please Login or Register  to view this content.

When I put this in the head of the module they told me that a "sub" or "function" is missing!