| Engine Version | Supports .mdb | Supports .accdb | Max Database Size | |----------------|---------------|-----------------|-------------------| | JET 4 (older) | Yes (up to Access 2003) | No | 2GB | | ACE 2010 | Yes | Yes (Access 2007-2010) | 2GB | | | Yes | Yes (Access 2007-2021/365) | 2GB |
If you're just building a new application, consider migrating from Access to SQL Server Express (free) or SQLite. But for supporting existing Access databases in a mixed environment? ACE 2016 is your answer. Have a specific error message? Drop it in the comments and I'll help decode it. access 2016 database engine
If you’ve ever tried to run a query on an Excel file with millions of rows, or needed to connect a non-Microsoft app to an Access database, you’ve likely run into a mysterious error: "The Microsoft Access database engine could not find the object" or "Unrecognized database format." | Engine Version | Supports
Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Data\MyDB.accdb;Persist Security Info=False; Have a specific error message
Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Data\Report.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";