FMS has worked with Microsoft Access since it debuted in 1992. There have been many Access versions since then with multiple service packs, hot fixes and updates. This paper offers a list of what and when it was released, feature differences between versions and additional details for the more recent versions.
Here are the definitions of the Release Type:
Note that each Access version is a separate panel below that you can collapse or expand by clicking the header.
|22- Sept-2015||RTM||Microsoft Page||
|Do things quickly with Tell Me, New Themes for Access Program, Export Linked Data Source Information to Excel, Templates get a Modern Look and Feel, Larger "Show Table" Dialog, Access Web App Features Coming to SharePoint on-premise Customers. Requires Windows 7 SP 1, Server 2008 R2, or later|
|8-Dec-2015||Update||KB3114379||16.0.4312.1000||Fixes the Microsoft Access 2016 and Invisible Picture Images problem|
Fixes: When you double-click certain action items in the Action Catalog panel in an Access Web App, the Access Web App may crash; after you change and save a query in the SQL view for a database in Access 2016, the query's SQL text disappears; when you link a Microsoft SharePoint list to an Access app, you receive the following error message: An error occurred in the client while attempting to communicate with the server.
Fixes the following issues: When you use the Max aggregate function in a query in Access 2016 that has the Polish language enabled, you receive the following error message: "Nie zdefiniowana funkcja 'Maksimum'"
Fixes the following issues: When you try to insert an app in Office 2016 applications, not only the apps for Office 2016 but also the apps for Office 2013 are displayed.
Fixes the following issues: When you drag an object from the Navigation pane to the macro designer in Access 2016, Access 2016 crashes.
Updates for Excel 2016, Office 2016, OneDrive for Business for Office 2016, OneNote 2016, Outlook 2016, PowerPoint 2016, Project 2016, Skype for Business 2016, Visio 2016, and Word 2016.
Fixes the following issues: Can't set the Field Size property for number fields in Table Design view.
Fixes the following issue: when you try to set properties of an ActiveX Data Objects (ADO) record set by using some Visual Basic codes in an Access 2016 form, you receive an error message.
Updates for Excel 2016, Office 2016, Office 2016 Language Interface, OneNote 2016, Outlook 2016, Project 2016, Skype for Business 2016. Visio 2016, and Word 2016.
Fixes the keyboard support for Office add-ins in the Backstage.
|15.0.4420.1017||Access Web Apps use SQL Server rather than SharePoint lists; Access desktop no longer supports: ADPs, replication, pivot charts/tables, Smart Tags, linked dBase tables, Visual Source Code integration, Upsizing Wizard, and Package Solution Wizard; Text and memo field types renamed to short and long text; Requires Windows 7, Server 2008 R2, or later|
|8-Oct-2013||Update||KB2768008||15.0.4535.1507||The latest fixes for the 32-bit and 64-bit editions of Access 2013 with stability and performance improvements.|
|12-Feb-2013||Update||KB2760350||15.0.4454.1000||The latest fixes for the 32-bit and 64-bit editions of Access 2013 with stability and performance improvements.|
|10-Sep-2013||Update||KB2752093||15.0.4535.1000||The latest fixes for the 32-bit and 64-bit editions of Access 2013 with stability and performance improvements.|
|10-Dec-2013||Hotfix||KB2825649||15.0.4551.1506||Assume that you use Access 2013 to create an Access Web App that has a table on a computer that is running Windows 8.1. Additionally, assume that the table contains a currency field. When you open the Access Web App, you receive the following error message: Access Services: an error has occurred.|
|8-Apr-2014||Hotfix||KB2863871||15.0.4601.1000||ADO recordset errors with UniqueTable property and type mismatch; Access web app problems with .app file|
|10-Oct-2014||Hotfix||KB2889947||15.0.4659.1000||VBA error codes in the range of 7865 to 7899 are off by one. For example, when you try to delete a nonexistent object by invoking the DoCmd DeleteObject method, you receive an error code 7873 instead of 7874.|
|11-Nov-2014||Update||KB2863859||15.0.4663.1000||Fixes: If Portuguese (Brazil) is the default display language for Access 2013, open the Visual Basic Editor, and click Tools, References. When you click the Browse button in the References dialog box, Access may crash.|
|10-Feb-2015||Update||KB2910930||15.0.4691.1000||When you click OK in the Print dialog to print a file, the printing does not start. You have to click OK again to start printing. This issue occurs on a Windows 7 or Windows Server 2008 Service Pack 2 (SP2)-based computer that has the Japanese Microsoft IME enabled in the language control panel.|
You may be unable to calculate some fields if the computer has not been restarted for a long time (24 days, for example); Opening Access Web App that contains very large data macros, error message that resembles the following: There was a problem accessing a property or method of the OLE object; When you try to delete multiple columns from a table, Access may crash; You create an Access web app.
Error may occur when you save the web app in the following scenarios: You add a new field, then you set the Index property to Yes (No Duplicates), and then you set the data type to Image; You add more than 32 new fields, and then you set the Index properties to Yes (No Duplicates)
When you try to open the saved web app, the error occurs again; Work correctly with design changes that were made to the Microsoft Forms ActiveX Control (FM20.dll) shared component library. For more information, see the following Microsoft Knowledge Base article: KB3025036 "Cannot insert object" error in an ActiveX custom Office solution after you install the MS14-082 security update
Improves translation of some user interface elements in Macedonian to multiple languages
to make sure the accuracy of the meanings in Access 2013.
Fixes Access crashes when you use Visual Basic for Applications (VBA)
languages to update the value of a combo box or a list that has a record
source on Access 2013 form.
Fixes when you try to split a database by using the Access Database
function in Microsoft Access 2013, the Access Database (.accdb) save
type is unavailable and the Microsoft Access Signed Package (.accdc) is
the only save type.
|14-Jul-2015||Update||KB3054950||15.0.4737.1000||Fixes: When you open multiple objects in design view and then try to switch to another view in Access 2013, Access 2013 may become unresponsive; When you undo a column deletion operation in table design view in Access 2013, Access 2013 crashes; The Conditional Formatting button does not work if the ribbon is collapsed in Access 2013; After you import a form or report or you copy and paste an existing form or report in an Access app, the theme colors are changed unexpectedly under the control of the newly created form or report.|
Fixes: When you start Access 2013 on a computer that was not restarted for a long time (for example, 24 days), the CPU usage
of the MSACCESS.EXE process becomes high. However, applying this update
will reintroduce the problem that is addressed by the
March 10, 2015, update for Access 2013 (KB2956176). As soon as this
update is installed, fields that are bound to expressions on forms may not
be recalculated when the computer has not been restarted for a long time.
|8-Dec-2015||Update||KB3114357||15.0.4779.1000||Fixed inability to calculate some fields in if the computer hasn't been restarted for a long time (24 days, for example), and after you change and save a query in the SQL view for a database in Access 2013, the query's SQL text disappears.|
Fixes the following issue:
Assume that you try to export a table to a text file in Access 2013. When you select the Advanced button the Export Text Wizard dialog box, Access 2013 may crash.
|08-Mar-2016||Update||KB3114735||15.0.4805.1000||Fixes the following issues: When you use the Max aggregate function in a query in Access 2016 that has the Polish language enabled, you receive the following error message: "Nie zdefiniowana funkcja 'Maksimum'"|
|12-Jul-2016||Office Update||KB3173835||Updates for Excel 2013, Lync 2013, Office 2013, OneDrive for Business for office 2013, Outlook 2013, PowerPoint 2013, Project 2013, SharePoint Server 2013 Client Components SDK, Visio 2013, and Word 2013.|
|06-Sep-2016||Update||KB1114948||15.0.4859.1000||Correctly applies the web browser on an Access 2013 form, conditional formatting that's applied to other controls may not be applied correctly.|
|03-Jan-2017||Update||KB3118349||15.0.1893.1000||Fixes the issue of Access 2013 unable to start with install of Office 2016 applications side by side.|
|03-Jan-2017||Office Update||KB3141474||15.0.4893.1000||Updates for Excel 2013, Office 2013, OneNote 2013, Outlook 2013, Project 2013, Skype for Business 2015, Visio 2013, and Word 2013.|
Introduced 64-bit version of Access, Access Web Apps using SharePoint Lists; data macros for ACCDBs, etc.
64-bit version changes ACCDE file format and is not backward compatible
Our blog: Microsoft Access 2010 Service Pack 1 VBA Project Compatibility Issues
|ADO 6.6.7601.17761||64-bit ADO 6.0 based application that is compiled in Windows 7 SP1 or in Windows Server 2008 R2 SP1 does not run in earlier versions of Windows.|
Fixes import of an Excel workbook that contains currency data into Access 2010; the currency data is not imported with the following error message: Could not find installable ISAM
|May 2013||SP2||KB2687455||14.0.7015.1000||Read our article on the Access updates and issues with Service Pack 2|
|22-July-2013||Extra||Free Download||14.0.7015.1000||Microsoft Access Database Engine 2010 Redistributable. This download installs components to transfer data such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.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.|
|13-Aug-2013||Hotfix||KB2760760||14.0.7104.5000||When you insert an EPS image into a database by using the Insert and Link option in the Insert Picture dialog box in Access 2010, the image is not embedded.|
|10-Sep-2013||Update||KB2687423||14.0.7104.5000||This security update resolves security vulnerabilities in Microsoft Access that could allow remote code execution when a specially crafted Access file is opened.|
|11-Nov-2014||Hotfix||KB2899528||14.0.7137.5000||Fixes issues that may arise for a PC running Access for more than 20 days. Access may consume excessive CPU resources. Background tasks do not execute. Calculated fields and domain functions (DLookup, DSum, DCount, etc.) do not display a value.|
|10-Mar-2015||Update||KB2837601||14.0.7145.5001||Works correctly with changes made to the Microsoft Forms ActiveX Control (FM20.dll) shared component library.|
|14-Jul-2015||Update||KB2965300||14.0.7153.5000||When you start Microsoft Access 2010 on a computer that has not been restarted for a long time (for example, 24 days), the CPU usage of the MSACCESS.EXE process becomes high. However, applying this update will reintroduce the problem that is addressed by the hotfix KB2899528 for Access 2010 November 11, 2014. As soon as this update is installed, fields that are bound to expressions on forms may not be recalculated when the computer has not been restarted for a long time.|
|13-Oct-2015||Update||KB3055045||14.0.7160.5000||You may be unable to calculate some fields in Access 2010 if the computer hasn't been restarted for a long time (24 days, for example). This issue occurs after you apply July 14, 2015, update for Access 2010 (KB2965300).|
|8-Mar-2016||Office Update||KB3085515||BAD!||This Office update breaks Microsoft Access 2010 databases in ACCDE and MDE formats. The update was removed by Microsoft and is no longer available. If you installed it, our blog post discusses the problems and how to uninstall it: Microsoft Office 2010 Update KB3085515 Causes Access ACCDE and MDE Databases to Crash|
|12-Jul-2016||Office Update||KB3173835||Updates for Excel 2010, Office 2010, Outlook 2010, PowerPoint 2010, Project 2013, and Word 2010.|
|27-Jan-2007||RTM||12.0.4518.1014||Introduced ACCDB database format with more secure encryption, ribbon interface, tabbed objects, report view, datasheet totals, simplified filtering, split form, output to PDF, date picker, graphics on buttons, replaced database container with navigation pane and search, attachment and multi-value field data types, form object anchoring, Web Browser control, image control with control source, directory level trust (2007 Enhancements). Requires Windows XP or later.|
|8-Apr-2007||Hotfix||KB935521||12.0.6012.5000||Fixes Runtime Error 3251 Operation is not supported for this type of object: When using Data Access Object (DAO) code to synchronize a replicated Access 2007 database. Also Runtime Error 3001 Invalid argument: When using a Microsoft Visual Basic for Applications (VBA) macro in Access 2007 to update records in a Microsoft Jet 3.x database.|
|11-Apr-2007||Hotfix||KB935875||12.0.6012.5000||Fixes when in Access 2007, you open a Microsoft Office Access 2003 database that contains a custom shortcut menu for a subform. Then, you right-click the subform. When you do this, the default shortcut menu is displayed instead of the custom shortcut menu.|
|27-Apr-2007||Hotfix||KB936519||12.0.6019.5000||Running a Microsoft Access project (.adp) in Access 2007, the project may run slowly. Or, the project may take longer than expected to respond to actions that are performed on the project.|
|24-Jun-2007||Hotfix||KB939185||12.0.6027.5000||You close or compact and then close an Access 2007 database. Then, you reopen the database. After you do this, you cannot use some menus or some menu items.|
|12.0.6211.1000||Office 2007 SP1 fixes KB936982|
|3-Oct-2008||Extra||Download||12.0.6211.1000||Access Database Engine to provide database connectivity to ACCDB files when Access 2007 or later isn't installed on the PC. Necessary to support connection strings using "ACE.OLEDB.12.0"|
|12.0.6423.1000||Lets you export reports to Excel. Supports memo fields in the mailing label wizard for addresses. Fixes issues that occur in the import data wizards, report printing and previewing, macros, Excel integration, and date filters. Includes updates to Access Developer Extensions. PDF Exporting feature is now built in. Recognizes trusted locations set at the machine level.|
|12.0.6423.1000||Updated Help (HxS) files for Microsoft Office Access 2007 with revisions and additions to Office Access Help and to Office Access Developer Help.|
|12.0.6510.5000||Fixes the slow performance when clicking fields, tabbing between fields, or scrolling down through fields in Datasheet view.|
|12.0.6510.5000||Fixes reports not showing all CAD images from the Attachment field. Also fixes the continuously flickering screen when you open a report that contains a graphic chart in Report View or Layout view.|
|12.0.6510.5000||Fixes query crashing (ODBC, inheritance and aggregation), last row not imported, decimal lookup field not displayed (from ODBC table).|
|12.0.6514.5000||Fixes parameter shown as number (ASCII value) instead of text on a report, stored procedure executed multiple times when opening a form/report, Navigation Pane and Status Bar issues after applying Service Pack 2, calculated field changes value while scrolling.|
|12.0.6520.5000||Fixes Office 2007 SP2 failure to update; some files objects can be deleted from the Navigation Pane even if you do not have permission; combo box becomes transparent when losing focus.|
|12.0.6521.5000||Ribbon options for rich text box now work in subforms.|
|12.0.6529.5000||Fixes Runtime crash after application of Service Pack 2|
|12.0.6535.5000||Fixes ApplyFilter macro does not accept subsequent parameters, and "There isn't enough memory to undo......" error when running 1.5MB query.|
|12.0.6539.5000||Fixes errors when importing data using the "Get External Data - Text File" wizard.|
|12.0.6542.5000||Fixes Access hanging on large attached table when clicking arrow beside date column, templates disappear (with Spanish MUI on Win XP/2003), and unable to link Sybase database if File DSN contains spaces.|
|10-Sep-2013||Update||KB2596825||12.0.6650.5000||This security update resolves security vulnerabilities in Microsoft Access that could allow remote code execution when a specially crafted Access file is opened.|
|12-Jul-2016||Office Update||KB3173835||Updates for Excel 2007, Excel Viewer 2007, Microsoft Office Compatibility Pack, Office 2007, and Word 2007.|
|27-Nov-2003||RTM||11.0.5614.0||Windows XP themes; databases can be created with digital signatures; explicit database trust to run VBA code|
|May 2004||SP1||KB872834||11.0.6355||Microsoft Office 2003 Service Pack 1 (SP1) contains significant security enhancements, and stability and performance improvements. Also includes many performance and feature enhancements to Microsoft Office Access 2003.|
|Oct 2004||Tool||Download||The Access 2.0 Converter is used by Microsoft Office Access 2003 to enable you to convert files from the Microsoft Access 2.0 file format.|
|27-Sep-2005||SP2||KB906460||11.0.7969||Microsoft Office 2003 Service Pack 2 (SP2) includes fixes previously released in Office 2003 Service Pack 1 (SP1) and in separate updates. Office 2003 SP2 combines the previously released fixes into one update.|
|18-Sep-2007||SP3||KB923618||11.0.8166||Microsoft Office 2003 Service Pack 3 (SP3) contains security enhancements and stability improvements. Some fixes that are included with Office 2003 SP3 were previously released in separate updates. Office 2003 SP3 combines the previously released fixes into one update.|
|18-Dec-2007||Hotfix||KB945674||11.0.8204||Fixed problems with SP3 such as combo box and list box displaying no value or incorrect values; problems working with bit fields in SQL Server tables; prevent unexpected closing; addressed problems with ADPs and VSS, and other issues.|
|7-Jun-1999||RTM||9.0.2720||New MDB Jet format with record locking, ADO and Unicode; Access Data Projects (ADPs) for SQL Server introduced; shared VBA and VB6 IDE|
|Fixed problems upsizing to SQL Server, SendObject, scroll bars, font list, Zoom Builder, OpenReport, etc.|
|24-Aug-1995||RTM||Added to Office 95 Professional Suite; Supports ActiveX controls; VBA replaces Access Basic; Requires Windows 95 or later|
|Apr 1994||RTM||Supports Windows 3.1; 4 MB RAM Minimum|
|May 1993||RTM||Added Access Basic programming language|
Microsoft Access debuted in November 1992 at the COMDEX convention in Las Vegas, Nevada. FMS President Luke Chung was there when Bill Gates introduced Microsoft Access, the first relational database program for Windows. It was Microsoft's first end-user database product and competed directly against Borland's dominance of the DBMS market with their dBase and Paradox products for DOS. FMS was a leader in the Paradox market and soon found Microsoft and Access to be a better partner and platform.
Read Luke's recollection of his experiences during that time in his Microsoft Access History: We were So Impressed article that was featured on the Microsoft site during Access' 10th Anniversary.
|Nov 1992||Product Debut||First Windows relational database (for Windows 3.0)|
We've compiled a similar comparison of different versions of Microsoft SQL Server Express: