DAO for 64 bit MS office Excel (dao360.dll,ACEDAO.dll)

If you have OFfice 2010 64bit and get error in string “DAO.DBEngine” in your Macros which use DAO dll like “dao360.dll” placed in
C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll it’s normal behavior,because dao360.dll it’s 32bit dll and willn’t work in 64bit office.
For this problem we have two solution:

1.Delete your 64bit office and setup 32bit office.

2.You will need ACEDAO.dll wich will replace dao360.dll in MS Office 2010 64bit..
Download “Microsoft Access Database Engine 2010 Redistributable” (http://www.microsoft.com/en-us/download/details.aspx?id=13255) 64bit version (AccessDatabaseEngine_x64.exe).Install it.
After that reboot your PC.
Open Your Excel file which use DAO and get error.Go to VBA editor (Alt+F11) open Tools-Reference in window with dlls uncheck old DAO (dao360.dll) after click Browse button, open C:\Program Files\Microsoft Office\Office14\ and add ACEDAO.dll.
After that save your file and check your error will be miss.All must work fine.If you get error about conflict when you add “ACEDAO.dll” to Reference you should uncheck old DAO library.

Leave a Reply

Your email address will not be published.