Toad World® Forums

TOAD 13.1 error "Could not load the Microsoft Access Database Engine ..."


#1

It looks like there is an incompatibility between TOAD and Microsoft Access: You get an error anytime you try to export the results to an access database (accdb). It does not matter if you have the right version of Access or not! The problem is that - for 32-bits TOAD - you need to export the results into an “mdb” extension database. If you use “accdb” you get the error.

THAT SHOULD NOT BE THE CASE. THIS IS A MAJOR FLAW THAT NEEDS TO BE CORRECTED.


#2

Please don’t write sentences in all caps here. I don’t know how you meant it, but It comes off as “yelling”. Nobody likes to be yelled at.

I just exported “select * from scott.EMP” in Toad 13.1.0.78, 32 bit, to an .accdb file without any errors.

The MS Access driver version could be the cause of the problem. The latest version is here:
https://www.microsoft.com/en-us/download/details.aspx?id=50040


#3

In addition to using the proper Access driver, as Mr. Dorlon mentioned, also make sure that the bitness of your Microsoft Database Access Engine matches the bitness of your Toad executable. See the following Knowledge Base Article on Quest’s Support site for more information:

https://support.quest.com/toad-for-oracle/kb/119056/error-when-trying-to-import-or-export-with-ms-access-could-not-load-the-microsoft-access-database-engine-


#4

I already checked the bitness of the TOAD versus Microsoft Access: I have the same 32-bits. Access works fine. If I change the extension to “mdb” then TOAD saves the data. If I use the “accdb” then it fails. Running TOAD on Windows 10 machines.

Regards,

Sami El-Murr


#5

Yeah, it wouldn’t work at all if the bits didn’t match. I believe installing the driver that I mentioned above will fix your problem, even if you already have the full version of MS Access already installed.


#6

What version of Access do you have?


#7

John,

I have the 32-bits version

Regards,

Sami El-Murr

Control System Engineering

ICS Cybersecurity Expert

+1-713-235-2556


#8

I have nearly the same version installed (mine is 16.0.11029.20045, 32 bit).

In Control Panel -> Programs and Features, I also have this, which is what Toad actually uses when writing the file.

The 2016 version that I mentioned before should work too (otherwise I would not have kept the link for it!), but the 2010 version is here:
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255