{"id":3726,"date":"2014-11-18T14:46:01","date_gmt":"2014-11-18T14:46:01","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3726"},"modified":"2026-09-16T17:21:17","modified_gmt":"2026-09-16T17:21:17","slug":"download-microsoft-access-database-engine-32-bit","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/tips\/download-microsoft-access-database-engine-32-bit.html","title":{"rendered":"Download Microsoft Access Database Engine (32-bit)"},"content":{"rendered":"<p><strong>Short answer:<\/strong> the 32-bit build of the Microsoft Access Database Engine 2016 Redistributable is the file <code>AccessDatabaseEngine.exe<\/code> &mdash; no <code>_X64<\/code> suffix. You can <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=54920\">download it from Microsoft<\/a>.<\/p>\n<p>Two things are worth knowing before you install it. First, the 32-bit engine is normally the right choice &mdash; 32-bit Office is still the default, and most data tools are 32-bit too. Second, it carries a memory limit that shows up as soon as a job gets big, and no amount of reinstalling will remove it. Both are explained below.<\/p>\n<h2>Which build do you actually need?<\/h2>\n<p>The Access Database Engine ships in two builds and they are <strong>not<\/strong> interchangeable. Your application, your Office installation and the engine all have to agree.<\/p>\n<table>\n<tr>\n<th><\/th>\n<th>32-bit &mdash; this page<\/th>\n<th>64-bit<\/th>\n<\/tr>\n<tr>\n<td>File name<\/td>\n<td><code>AccessDatabaseEngine.exe<\/code><\/td>\n<td><code>AccessDatabaseEngine_X64.exe<\/code><\/td>\n<\/tr>\n<tr>\n<td>Install it when<\/td>\n<td>the program that reads the database is 32-bit<\/td>\n<td>that program is 64-bit<\/td>\n<\/tr>\n<tr>\n<td>Symptom if you pick wrong<\/td>\n<td>the provider never shows up in the list<\/td>\n<td>&#8220;Provider cannot be found&#8221; still appears after installing<\/td>\n<\/tr>\n<\/table>\n<h2>Why 32-bit is usually the one people need<\/h2>\n<p>Microsoft Office installs as 32-bit unless someone deliberately picks the 64-bit option, and that choice has to be made at install time. Most older data tools, reporting add-ins and ODBC clients are 32-bit as well. If the program that reads your Access database sits under <code>C:\\Program Files (x86)<\/code>, it is 32-bit and it needs this engine.<\/p>\n<p>To confirm on your own machine: in Office, File &rarr; Account &rarr; About Excel shows the bitness on the first line. For any other program, open Task Manager, go to the <em>Details<\/em> tab and look for the &#8220;(32 bit)&#8221; label next to the process name.<\/p>\n<h2>The 32-bit ceiling you will run into eventually<\/h2>\n<p>A 32-bit process can address roughly 2 GB of memory, and the Access engine loads much of its working set inside the calling process. A wide query, or a table with long Text and Memo columns, can exhaust that space even on a machine with plenty of free RAM. The job then fails with an out-of-memory error that looks like a data problem but is really an addressing limit.<\/p>\n<p>If that is what brought you here, installing this driver will not help. The limit belongs to the 32-bit build itself, and it is the main reason to move the work to a 64-bit tool.<\/p>\n<h2>No driver, and no 2 GB ceiling<\/h2>\n<p>Withdata&#8217;s Access tools open .mdb and .accdb files directly in a 64-bit process, so they never load the ACE provider and never hit that ceiling. No Access Database Engine, no ODBC or OLEDB driver, no Microsoft Access installation &mdash; on Windows, Linux and macOS.<\/p>\n<ul>\n<li><a href=\"\/tools\/db\/export-from-access\">Export Access tables to CSV, Excel, JSON, TXT or SQL<\/a><\/li>\n<li><a href=\"\/tools\/db\/import-to-access\">Import CSV, Excel or text files into Access<\/a><\/li>\n<li><a href=\"\/tools\/db-to-db\/copy-between-access\">Copy data between two Access databases<\/a><\/li>\n<li><a href=\"\/tools\/db\/migrate-for-access\">Migrate Access to MySQL, SQL Server, PostgreSQL and others<\/a><\/li>\n<\/ul>\n<p>Our <a href=\"\/tools\/file\/excel\/list\">Excel tools<\/a> work the same way, without Microsoft Excel installed and without this driver.<\/p>\n<h2>If you still need Microsoft&#8217;s driver<\/h2>\n<p>Access Database Engine 2016 Redistributable installs the ACE provider that older applications use to read .mdb, .accdb, .xls, .xlsx and .xlsb files. Microsoft publishes it here: <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=54920\">Microsoft Access Database Engine 2016 Redistributable<\/a>. Choose the <strong>32-bit<\/strong> download &mdash; <code>AccessDatabaseEngine.exe<\/code>, not the <code>_X64<\/code> one.<\/p>\n<p><strong>See also:<\/strong> <a href=\"\/blog\/tips\/download-microsoft-access-database-engine-64-bit.html\">the 64-bit version of this driver<\/a> &middot; <a href=\"\/blog\/tips\/missing-msvcr110-dll.html\">Missing msvcr110.dll<\/a> &middot; <a href=\"\/blog\/tips\/about-unable-to-load-odbcji32-dll.html\">Unable to load odbcji32.dll<\/a> &middot; <a href=\"\/tools\/db\/\">all database tools<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Short answer: the 32-bit build of the Microsoft Access Database Engine 2016 Redistributable is the file AccessDatabaseEngine.exe &mdash; no _X64 suffix. You can download it from Microsoft. Two things are worth knowing before you install it. First, the 32-bit engine is normally the right choice &mdash; 32-bit Office is still the default, and most data [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[1316],"class_list":["post-3726","post","type-post","status-publish","format-standard","hentry","category-tips","tag-microsoft-access-database-engine"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=3726"}],"version-history":[{"count":14,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3726\/revisions"}],"predecessor-version":[{"id":45671,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3726\/revisions\/45671"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}