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

**URL:** <https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 5, 2018, 1:30pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617 "2018-12-05T13:30:38Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![seelmurr](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@seelmurr](https://forums.toadworld.com/u/seelmurr)\
**Post date:** [December 5, 2018, 1:30pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/1 "2018-12-05T13:30:38Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 5, 2018, 2:34pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/2 "2018-12-05T14:34:41Z")

</div>

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](https://www.microsoft.com/en-us/download/details.aspx?id=50040)

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [December 5, 2018, 4:27pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/3 "2018-12-05T16:27:47Z")

</div>

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-](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-)

---

<div class="post-metadata">

**Author:** ![seelmurr](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@seelmurr](https://forums.toadworld.com/u/seelmurr)\
**Post date:** [December 5, 2018, 4:53pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/4 "2018-12-05T16:53:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 5, 2018, 4:58pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/5 "2018-12-05T16:58:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 5, 2018, 5:35pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/6 "2018-12-05T17:35:08Z")

</div>

What version of Access do you have?

---

<div class="post-metadata">

**Author:** ![seelmurr](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@seelmurr](https://forums.toadworld.com/u/seelmurr)\
**Post date:** [December 5, 2018, 6:05pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/7 "2018-12-05T18:05:02Z")

</div>

John,

I have the 32-bits version

![](https://global.discourse-cdn.com/quest/original/2X/8/820dd1057b835cb61723f33fcea8bef316fa0686.jpeg)

Regards,

Sami El-Murr

Control System Engineering

ICS Cybersecurity Expert

+1-713-235-2556

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 5, 2018, 6:50pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/8 "2018-12-05T18:50:43Z")

</div>

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.

 ![image](https://global.discourse-cdn.com/quest/original/2X/9/94bddca4da5898e93da53dd8d76c3cb34d8234b3.jpeg)

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](http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255)

---

<div class="post-metadata">

**Author:** ![dwight.bird](https://avatars.discourse-cdn.com/v4/letter/d/a4c791/32.png) [@dwight.bird](https://forums.toadworld.com/u/dwight.bird)\
**Post date:** [June 4, 2019, 11:09pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/9 "2019-06-04T23:09:17Z")

</div>

I don't know if I should post here, or start a new topic. I am receiving the same error. I have Toad for Oracle 13.1 64 bit, and MS Office 2016 64 bit. Fresh installs of both. I have two Oracle installations, 12.2 64 bit, and 11.? 32 bit which I require for SAP Business Object IDT. I don't know where to look or what to look for to see how the products connect together to be able to export the data to any form of an access database.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 5, 2019, 12:06am UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/10 "2019-06-05T00:06:33Z")

</div>

Toad 11.x does not connect/communicate with Toad 13.1 at all. Which version of Toad are you having problems with?

Sounds like you should keep your export to Access in the 13.1 version of Toad.

---

<div class="post-metadata">

**Author:** ![dwight.bird](https://avatars.discourse-cdn.com/v4/letter/d/a4c791/32.png) [@dwight.bird](https://forums.toadworld.com/u/dwight.bird)\
**Post date:** [June 5, 2019, 5:37am UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/11 "2019-06-05T05:37:24Z")

</div>

Sorry, 11.x was referring to a 32bit Oracle installation like 11g, not Toad. I need my Toad 13.1 64bit to talk to my Access 2016 64bit.

Thanks

---

<div class="post-metadata">

**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\
**Post date:** [November 2, 2020, 9:49pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/12 "2020-11-02T21:49:51Z")

</div>

John, I have been using Schema Browser\> Tables. Select table(s) Data export as Access Database Files. I have an empty directory mapped that has always accepted these files. An external user later opens these Access Database files with 'R' for use in reports.

We had been using ACCESS 13 for years with no issues with TOAD up to 13.last... Since last report time, I have moved to TOAD for Oracle 14.. -- and we moved to Office 365 which changed all Office applications to 64-bit.

Now I am getting a message from Toad stating: "Could not load the Microsoft Access Database Engine. This is not the full MS ACCESS product, just the runtime engine. The 64 bit version is required for this version of TOAD."I tried with the old 32 but installation of TOAD and got the same message, except that it stated that the 32 but version is required for this version of TOAD -- which is 32 bit -- That is why I thought moving to 64 bit toad would work -- but it did not.

John -- should the same MS drive mentioned above help now, or will I just be looking for a later driver ? -- Thank you!

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 2, 2020, 10:10pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/13 "2020-11-02T22:10:19Z")

</div>

Hi John,

The latest version that I am aware of is here:  
[https://www.microsoft.com/en-us/download/confirmation.aspx?id=50040](https://www.microsoft.com/en-us/download/confirmation.aspx?id=50040). You'll definitely want the 64 bit version of it with 64 bit Toad.

I tried to install the 64 bit version of it on my PC to test it before posting this, but I have 32 bit MS Office installed, and they won't install together.

**Edit** : after a quick search, I also found this  
**Note** : This works with Toad 13.3 64 bit and 14.0 64 bit, but only install this if you don't have the full MS Access already installed. If you do, it will downgrade your Access installation to the runtime.

> **[Download and install Microsoft 365 Access Runtime](https://support.microsoft.com/en-us/office/download-and-install-microsoft-365-access-runtime-185c5a32-8ba9-491e-ac76-91cbe3ea09c9)**
>
> Download the Microsoft 365 Access Runtime which allows you to run Microsoft 365 Access applications if you don't have the desktop version of Microsoft 365 Access and need to use an application built to run with Access 2010 or later.

-John

---

<div class="post-metadata">

**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\
**Post date:** [November 2, 2020, 10:24pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/14 "2020-11-02T22:24:41Z")

</div>

I will give it a go -- Thank you.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 2, 2020, 10:25pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/15 "2020-11-02T22:25:31Z")

</div>

I found a Win 10 machine with no office installed. Trying the new one now. Will post the results as soon as I know something.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 2, 2020, 10:31pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/16 "2020-11-02T22:31:19Z")

</div>

The new one works with both Toad 13.3 64 bit and 14.0 64 bit.

---

<div class="post-metadata">

**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\
**Post date:** [November 3, 2020, 2:10pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/17 "2020-11-03T14:10:04Z")

</div>

The pc executing the export has OFFICE 365 - installed by a push -  
Would you expect this MS fix to have any effect on a machine that has the Office 365 installed?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 3, 2020, 2:13pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/18 "2020-11-03T14:13:28Z")

</div>

I wouldn't expect any problems from that. I've had earlier versions of the runtime installed with MS Office on the same PC, without problems. Haven't tried it with this version though.

---

<div class="post-metadata">

**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\
**Post date:** [November 3, 2020, 2:17pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/19 "2020-11-03T14:17:07Z")

</div>

Runtime engine is discussed on the last URL -- will work through that

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 3, 2020, 2:19pm UTC](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617/20 "2020-11-03T14:19:51Z")

</div>

It says "MS 365 Access Runtime".

I've got MS Office 2016 installed on a VM. I can try installing this on top and see what happens. I think it'll be fine though.

[Next page](https://forums.toadworld.com/t/toad-13-1-error-could-not-load-the-microsoft-access-database-engine/44617.md?page=2)
