I recently upgraded from office 2007 to 2010. I achieved this by inserting the CD into my PC and allowing the program to remove 2007 and upgrade to 2010. During the installation process, I was told that I needed to install the 64Bit version of office because I had Access Database Engine 2010 64Bit installed. I need the Access Database driver because my website uses classic ASP to connect to accdb Access Databases. My PC is a work PC and a web development Server.

After installing Office, I received error messages telling me that the VBA runtime environment could not be initialized. I researched the issue and found Microsofts official answer to be, Install the 32Bit version of office.  You probably dont need the 64Bit version anyways.

After several days of research, I found instructions online that explained how to install the 32Bit version of office 2010 alongside the 64Bit Access Database Engine 2010. (http://knowledge.autodesk.com/support/autocad-civil-3d/troubleshooting/caas/sfdcarticles/sfdcarticles/How-to-install-64-bit-Microsoft-Database-Drivers-alongside-32-bit-Microsoft-Office.html )

This worked and I was happy, that was, until I rebooted my PC. I then got a cryptic error message every time the site tried to talk to a database, A trappable error (C0000005) occurred in an external object. The script cannot continue running.

So far the only answer is to uninstall the Access Database Engine and reinstall it. This is becoming a pain as Ive has to reinstall the driver twice this week and its only Tuesday.

How do I get the driver to keep working even after a reboot?

Mike

Hi,

According to your description, >>I need the Access Database driver because my website uses classic ASP to connect to accdb Access Databases. My PC is a work PC and a web development Server.<< Did this operation have to use 64 bit Access Database Engine 2010? If no, please try to use 32 bit Access Database Engine 2010. Microsoft does not recommend mix with 32bit and 64bit Office suits.

Then, this error A trappable error (C0000005) occurred in an external object. The script cannot continue running" that the C0000005 is the Access Violation Exception. This occurs when code attempts to read memory that it hasn't allocated or missing dependency. Because Office 32bit and 64bit version using different DLL folder, like: C:\Windows\System32 or C:\Windows\SysWOW64. Thus, the code might be error.

I recommend you use 32 bit Access Database Engine 2010 directly.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

I can't get the 32 bit driver to work. Once installed, I get the following message:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

This is why I'm using the 64 bit driver. it works like a charm. But as you said, it does not play nice with 32 bit office.

Any ideas as to why 32 bit drivers don't work or how to get 64 bit to not need to be reinstalled after every reboot?

By the way, the provider is: Microsoft.ACE.OLEDB.12.0;

Hi,

This error >>

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed. << might be caused by the IIS settings, please check the site's Application Pool in IIS / Application Pools / YourPoolHere / Advanced Settings :

1) Managed Pipeline Mode : Classic
2) Advanced / Enable 32-Bit Applications: True

Reference:

http://forums.iis.net/t/1151292.aspx?ASP+db+connection+problem+in+IIS7

Microsoft does not recommend mix with 32bit and 64bit version, the method that you found is not a official solution. Thus, please try to troubleshoot the error and use both of 32bit Office and driver in same pc.

PS: If you have 32bit Access, it includes the provider : Microsoft.ACE.OLEDB.12.0;

Regards,

George Zhao
TechNet Community Support

Thanks for the solution. I didn't know that I had to turn on support for 32 bit applications and since I had not, that is why the 32 bit drivers were not working. My PC is now happy since all office products are 32 Bit. Thanks much.