Achieve the extraordinary
Microsoft 365 delivers cloud storage, security, and Microsoft Copilot in your favorite apps—all in one plan.
This download will install a set of components that can be used to facilitate transfer of data between Microsoft Office System files and non-Microsoft Office applications.
Important! Selecting a language below will dynamically change the complete page content to that language.
-
File Name:
accessdatabaseengine_X64.exe
accessdatabaseengine.exe
This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. For more information, including the End User License Agreement (EULA) see Download and install Microsoft 365 Access Runtime.
ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
The Access Database Engine 2016 Redistributable is not intended:
- As a general replacement for Jet (If you need a general replacement for Jet you should use SQL Server Express Edition).
- As a replacement for the Jet OLEDB Provider in server-side applications.
- As a general word processing, spreadsheet or database management system
-To be used as a way to create files. (You can use Microsoft Office or Office automation to create the files that Microsoft Office supports.) - To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior. Examples would include a program that is run from task scheduler when no user is logged in, or a program called from server-side web application such as ASP.NET, or a distributed component running under COM+ services.
-
Supported Operating Systems
Windows 10, Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2012, Windows 7, Windows 8, Windows 8.1
Windows 11, Windows 10, Windows 8.1, Windows 8, Windows 7 Service Pack 1, Windows 10 Server, Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2
-
Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel.
To install this download:
- Download the file by clicking the Download button and saving the file to your hard disk.
- Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
- Follow the instructions on the screen to complete the installation.
To use this download:
- If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
- If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:
File Type (extension) Extended Properties
———————————————————————————————
Excel 97-2003 Workbook (.xls) «Excel 8.0»
Excel Workbook (.xlsx) «Excel 12.0 Xml»
Excel Macro-enabled workbook (.xlsm) «Excel 12.0 Macro»
Excel Non-XML binary workbook (.xlsb) «Excel 12.0» - If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
- If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
To remove this download:
To remove the download file itself, delete the file AccessDatabaseEngine.exe- On the Start menu, point to Settings and then click Control Panel.
- Double-click Add/Remove Programs.
- In the list of currently installed programs, select “Microsoft Access database engine 2016” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
- Click Yes or OK to confirm that you want to remove the program.
-
The Office System Drivers are only supported under certain scenarios, including:
- Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files.
- To transfer data between supported file formats and a database repository, such as SQL Server. For example, to transfer data from an Excel workbook into SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services (provided the SSIS jobs run in the context of a logged-on user with a valid HKEY_CURRENT_USER registry hive).
С 15.06.2022 г. IE 11 не поддерживается
IE11 станет недоступным с 14.02.2023. Сайты, созданные для IE, можно перезапустить в режиме IE в Microsoft Edge.
Скачанная программа установит набор компонентов, с помощью которых можно упростить передачу данных из файлов системы Microsoft Office и других приложений.
Важно! Если выбрать язык ниже, содержимое страницы динамически отобразится на выбранном языке.
-
Date Published:
10.03.2023
File Name:
accessdatabaseengine_X64.exe
accessdatabaseengine.exe
В результате скачивания будет установлен набор компонентов, которые упрощают передачу данных из существующих файлов Microsoft Office, таких как файлы Microsoft Office Access (MDB и ACCDB) и файлы Microsoft Office Excel (XLS, XLSX и XLSB) в другие источники данных, такие как Microsoft SQL Server. Также поддерживается возможность подключения к существующим текстовым файлам. Устанавливаются драйверы ODBC и OLEDB, которые позволяют разработчикам приложений подключаться к файлам в формате Office.
Распространяемое ядро СУБД Microsoft Access 2016 не предназначено для указанных ниже применений.
- В качестве основной замены для Jet (для замены используйте SQL Server Express Edition).
- В качестве основной замены поставщика OLE DB для Jet в серверных приложениях.
- Для создания файлов в качестве универсального текстового редактора, редактора электронных таблиц или системы управления базами данных. (Для создания файлов, поддерживаемых системой Microsoft Office, можно использовать Microsoft Office или средства автоматизации Office.)
- Для работы с системными службами и серверными приложениями, в которых код выполняется под системной учетной записью или работает с одновременно с несколькими удостоверениями пользователей, или является реентерабельным без отслеживания состояния. Это может быть программа, запускаемая из планировщика заданий при отсутствии выполнивших вход пользователей, программа, вызываемая из серверного веб-приложения, например ASP.NET, или распространяемый компонент, работающий под управлением служб COM+.
-
Поддерживаемые операционные системы
Windows 10, Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2012, Windows 7, Windows 8, Windows 8.1
Windows 10, Windows 8.1, Windows 8, Windows 7 с пакетом обновления 1, Windows 10 Server, Windows Server 2012 R2, Windows Server 2012 или Windows Server 2008 R2
-
Примечание. Перед установкой скачанного продукта потребуется удалить все предыдущие версии ядра СУБД Access (через компонент установки и удаления программ в панели управления).
Установка скачанной программы
- Нажмите кнопку Загрузить и сохраните файл на жестком диске.
- Дважды щелкните сохраненный на жестком диске программный файл AccessDatabaseEngine.exe, чтобы запустить программу установки.
- Выполните установку, следуя инструкциям на экране.
Применение
- Если вы являетесь пользователем, ознакомьтесь с инструкциями по работе с соответствующим драйвером в документации приложения.
- Если вы — разработчик приложений и пользуетесь OLE DB, задайте аргументу Provider свойства ConnectionString значение Microsoft.ACE.OLEDB.12.0.
При подключении к данным Microsoft Office Excel добавьте строку подключения Extended Properties OLE DB, соответствующую типу файла Excel:
Тип файла (расширение) Extended Properties
———————————————————————————————
Книга Excel 97-2003 (XLS) «Excel 8.0»
Книга Excel (XLSX) «Excel 12.0 Xml»
Книга Excel c поддержкой макросов (XLSM) «Excel 12.0 Macro»
Двоичная книга Excel (XLSB) «Excel 12.0» - Если вы — разработчик приложений и пользуетесь OLE DB для подключения к данным Microsoft Office Access, задайте для строки подключения значение Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file.
- Если вы — разработчик приложений и пользуетесь OLE DB для подключения к данным Microsoft Office Excel, задайте для строки подключения значение Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file.
Удаление скачанного файла
Чтобы удалить скачанную программу, удалите файл AccessDatabaseEngine.exe.- Откройте меню «Пуск» и выберите пункт Панель управления в области параметров.
- Дважды щелкните элемент Установка и удаление программ.
- В списке установленных программ выберите Ядро Microsoft Access 2016 и нажмите кнопку Удалить или Добавить/удалить. Если на экране появится диалоговое окно, следуйте дальнейшим инструкциям, чтобы удалить программу.
- Нажмите кнопку Да или ОК, чтобы подтвердить удаление программы.
-
Системные драйверы Office поддерживаются только при определенных сценариях.
- Классические приложения, читающие данные из файлов различных форматов, например файлов Microsoft Office Access, Microsoft Office Excel и текстовых файлов, и записывающие данные в них.
- Передача данных между файлами поддерживаемых форматов и репозиторием базы данных, таким как SQL Server. Например, это может быть передача данных из книги Excel в SQL Server посредством мастера импорта и экспорта SQL Server или SQL Server Integration Services (при выполняющихся заданиях SSIS и наличии выполнившего вход пользователя с действительным кустом реестра HKEY_CURRENT_USER).
Microsoft Access Database Engine 2016 Redistributable |
This download will install a set of components that can be used to facilitate transfer of data between Microsoft Office System files and non-Microsoft Office applications.
- This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported.ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
The Access Database Engine 2016 Redistributable is not intended:
- As a general replacement for Ace (If you need a general replacement for Ace you should use SQL Server Express Edition).
- As a replacement for the Jet OLEDB Provider in server-side applications.
- As a general word processing, spreadsheet or database management system-To be used as a way to create files. (You can use Microsoft Office or Office automation to create the files that Microsoft Office supports.)
- To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior. Examples would include a program that is run from task scheduler when no user is logged in, or a program called from server-side web application such as ASP.NET, or a distributed component running under COM+ services.
Files
Status: LiveThis download is still available on microsoft.com. Since you’re using a legacy operating system, the downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020. |
| File | Size |
|---|---|
| AccessDatabaseEngine.exe
SHA1: |
76.80 MB |
| AccessDatabaseEngine_X64.exe
SHA1: |
78.82 MB |
System Requirements
Operating Systems: Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2
- Windows 10, Windows 8.1, Windows 8, Windows 7 Service Pack 1, Windows 10 Server, Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2
Installation Instructions
- Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel.
To install this download:
- Download the file by clicking the Download button and saving the file to your hard disk.
- Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
- Follow the instructions on the screen to complete the installation.
To use this download:
- If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
- If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:
File Type (extension) Extended Properties
———————————————————————————————
Excel 97-2003 Workbook (.xls) «Excel 8.0»
Excel Workbook (.xlsx) «Excel 12.0 Xml»
Excel Macro-enabled workbook (.xlsm) «Excel 12.0 Macro»
Excel Non-XML binary workbook (.xlsb) «Excel 12.0» - If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
- If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
To remove this download:
To remove the download file itself, delete the file AccessDatabaseEngine.exe- On the Start menu, point to Settings and then click Control Panel.
- Double-click Add/Remove Programs.
- In the list of currently installed programs, select “Microsoft Access database engine 2016” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
- Click Yes or OK to confirm that you want to remove the program.
Readers help support Windows Report. We may get a commission if you buy through our links.
Read our disclosure page to find out how can you help Windows Report sustain the editorial team. Read more
Microsoft Access Database Engine contains essential components that make it possible for Microsoft Office programs to interact with software services and applications that do not belong to Microsoft. For instance, if you are working in a program that gives you the possibility to export tables directly to Microsoft Access, then you need the database engine to make that happen.
The Microsoft Access Database Engine is available in multiple editions, which mainly depend on which Microsoft Office product you’re using. The hint is in the year. As such, if you use Microsoft Office 2016, then you need Microsoft Access Database Engine 2016.
Our Review
- Pros
- Connects Office and non-Office products
- Easy to download and install
- Completely free to use
- Cons
- No 64-bit version for Database Engine 2016
Check out the system requirements, installation instructions, a few notable aspects you should be aware of, and our final verdict for Microsoft Access Database Engine.
Microsoft Access Database Engine system requirements
The database engine for Microsoft Office can be installed on these Windows editions:
- Windows 10, 8, 8.1, 7, Server 2012 , 2012 R2, 2008 R2 (Database Engine 2016, 2010, Access Runtime 2013)
- Windows Vista SP1, 32-bit XP SP3 (Database Engine 2010)
How to install Microsoft Access Database Engine
There are multiple editions of the Microsoft Access Database Engine available for download, depending on which Office version you’re using. It also depends on your system’s architecture type, service pack, and preferred language.
As such, you should make sure to check which conditions you match before downloading the correct Microsoft Access Database Engine setup file for your Windows PC.
Furthermore, you have to uninstall any previous version of the Microsoft Access Database Engine before setting up a newer version, in order to avoid any software compatibility issues.
The setup operation itself is fast and easy. You can review and accept the license terms, as well as specify the installation folder. It’s not necessary to restart the computer to complete the setup.
For application developers
If you’re a software developer looking for an OLEDB solution, then make sure to set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”. Moreover, if you want to link a tool to spreadsheets in Microsoft Excel, take the Excel file type into account when setting the OLEDB Extended Properties.
Follow the table below:
| File type | Extended Properties |
|---|---|
| Excel 97-2003 Workbook (.xls) | «Excel 8.0» |
| Excel Workbook (.xlsx) | «Excel 12.0 Xml» |
| Excel Macro-enabled workbook (.xlsm) | «Excel 12.0 Macro» |
| Excel Non-XML binary workbook (.xlsb) | «Excel 12.0» |
To connect to Excel using the ODBC driver, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”. And, when it comes to Access, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”.
Some notable aspects of Microsoft Access Database Engine
Users should know that Microsoft Access Database Engine isn’t designed to take the place of the Microsoft Jet Database Engine. In that case, you should turn to SQL Server Express Edition instead. It shouldn’t succeed the Jet OLEDB provider when it comes to server-side applications either.
Unless it’s evident, Microsoft Access Database Engine can’t be used for writing text, creating spreadsheets or managing databases because it’s not a software application like Microsoft Word, Excel or Access. You still need to separately download and install those programs if you want to connect them with non-Office applications using the database engine.
Lastly, Microsoft Access Database Engine shouldn’t be used as a background service or service-side application operated by a system account. Similarly, it shouldn’t handle multiple user identities at once.
A required tool for Office and non-Office interoperability
Taking everything into consideration, Microsoft Access Database Engine is a necessary tool that you must install on your Windows PC if you want to facilitate communications between Microsoft Office and non-Office software products, without having to go through manual configurations.
With its aid, you can export databases directly to Microsoft Access, for example, regardless of the program you’re working with. Unfortunately, it’s not currently possible to download the 64-bit version of Microsoft Access Database Engine 2016.
FAQ: Learn more about Microsoft Access and Database Engine
- Do I need Microsoft Access Database Engine?
Yes, you need the Microsoft Access Database Engine if you want your software applications to communicate with non-Office tools, as well as to avoid ODBC driver errors. It’s actually a requirement listed on the websites of many software products, but it’s usually downloaded and installed automatically.
- How do I download Microsoft Access ODBC driver?
Click the “Download” button we provided above to open a new page and select the Microsoft Access Database Engine version you need: 2016, 2013 or 2010. This takes you to a Microsoft page, where you can choose the language and architecture type. The download begins right afterward.
- What causes Access database corruption?
Malware attacks, interrupted file transfers, power outage, and hardware failure are just a few that cause Access database corruption. However, you can fix corrupted Access databases by following our guide.
Madalina Dinita
Networking & Security Specialist
Madalina has been a Windows fan ever since she got her hands on her first Windows XP computer.
She is interested in all things technology, especially emerging technologies — AI and DNA computing in particular.
Prior to joining the WindowsReport team, she worked in the corporate world for a number of years.
The Access Database Engine, an innovative component designed by Microsoft, provides users with an effective means of accessing, managing, and interacting with diverse databases. The file formats accommodated by it include Microsoft Access and other related files, including Excel formats that contain embedded data sources.
The Access Database Engine component plays a central role in facilitating seamless connectivity and seamless interaction between applications and external programs and file databases. Database files created through Microsoft Access software or other applications that apply file formats supported by the Access Database Engine can be explored and utilized optimally through this component.
A concrete example that mirrors the Access Database Engine utility is when a user wants to access and process data placed in the Microsoft Excel file format or in a Microsoft Access file, through other applications such as the use of the C# and VB.NET using Visual Studio IDE or the use of Python programming language with another IDE. The flexibility afforded by this component allows users to bridge the gap between these files and modern applications, enabling efficient and integrated data manipulation.
Not only does it allow interaction, the Access Database Engine also functions as a support for analytical and managerial capabilities. Users can easily apply software and other tools to perform in-depth analysis of the data stored in these files. Thus, access to valuable information can be realized without having to be fixated on the platform from which the data originated.
Continuous innovation in the Access Database Engine domain opens up new opportunities for application development and data utilization. This component is an important bridge between scattered data in file formats and modern applications that require flexible data integration. Thus, productivity increases while the challenge of manipulating complex files is overcome.
Technology development trends show that the Access Database Engine is not a stand-alone entity, but rather part of an increasingly connected ecosystem. Integration with various platforms, programming languages, and analytical tools proves that these components are constantly adapting to meet the demands of the present and the future. Thus, the full potential of database files in diverse formats can be accessed and utilized more widely, thanks to the integral role of the Access Database Engine.
Accessdatabaseengine_x64.exe
accessdatabaseengine_x64.exe is a version of the Access Database Engine that can only be installed if you are using a 64bit version of Microsoft Office. Thus, you cannot install this component if your version of Microsoft Office, including Access, and Excel has a 32-bit version.
Accessdatabaseengine_x32.exe
While the accessdatabaseengine_x32.exe version or usually just called accessdatabaseengine.exe is the version that can be installed if your Microsoft Office is a 32bit version.
Tips on How to Install AccessDatabaseEngine
Because maybe most of you have difficulty determining whether your Microsoft Office version is 32bit or 64bit version, it is highly recommended that you download both, then install the one that can work well, because if your version of Microsoft Office is different there will be a rejection at the beginning of the installation so it will not be a problem later for your system.
Accessdatabaseengine Download
You can download the 32bit and 64bit versions of Accessdatabaseengine via the link below. The version we share only works for Microsoft Office 2016 and above, but you can still try installing it if you have another version of Microsoft Office.
File Size: 157MB
Office Support: Microsoft Office 2016, 2019, Office 365 etc.
Operating System: Windows 7/8/10/11 or above
Maybe you liked other articles too?