Microsoft Download Center Archive
![]() | 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. The downloads below will come directly from the Microsoft Download Center. |
File | Size |
---|---|
![]() SHA1: 1fb69faf425b276108b4f3d7714e8d8161209486 | 76.80 MB |
![]() SHA1: 277ea5ebcd18b8b98d82c9dc53399b4fe864ca51 | 78.82 MB |
File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.
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.
- 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 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.