Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and 97Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History

Overview

FMS has worked with Microsoft Access since it debuted in 1992. There are many Access versions since then with multiple service packs, hot fixes and updates.

This page offers a list of what and when it was released, some feature differences between versions, and additional details for the more recent updates.

For a graphical matrix comparing major features among Access versions, visit this page:

Definitions of the Release Types

  • RTM = Release to Manufacturing and is the original release for each version
  • SP = Service Pack is a formal new release for the version and includes multiple fixes
  • SR = Service Release is the legacy name for Service Pack
  • Hotfix = an "inline" release to address critical issues and not expected to be installed by all users
  • Updates = an accumulation of multiple hotfixes that aren't quite a service pack release
  • Extra = Additional features

Microsoft Access 2019Note that Access 2019 has two different versions depending on whether it's on-premise or Office 365 subscriptions. Office 365 offers continuous updates that occur automatically monthly or every six months depending on your settings. For more information, visit these Microsoft Access pages:

To get more information and to purchase Office 2019, visit these Microsoft pages:


Update Channels

This list shows the update channels for Microsoft 365 Apps.

Security and non-security updates, if needed are usually released on the second Tuesday of the month for all channels. For more information on the update channels, visit Overview of update channels for Microsoft 365 Apps.

Release Type and Date Version and Build Description

Current Channel
June 30, 2020

Version 2006 (13001.20266)

This update fixed the following issue:
  • The Query execution was taking approximately twice as long to complete than expected.

Current Channel
June 24, 2020

Version 2005 (12827.20470)

This update fixes the following issues:
  • Users were experiencing their app crashing when calling the Date/Time Extended data type into their code.
  • If the user manipulates Decimal fields (Access DataType=Number/FieldSize=Decimal, or SQL DataType=Decimal) using DAO (Data Access Objects), Microsoft Access may crash. If the user hovers a Field variable with Decimal type in VBA code, the user may see that the field value is not being displayed properly; either reading as ????? or giving a Type Mismatch error, or Microsoft Access may crash.

Monthly Enterprise Channel
June 9, 2020

Version 2004 (12730.20430)

This update features the following:

Current Channel
June 8, 2020

Version 2005 (12827.20010)

If you are on Version 2005, build 12827.20010 or greater, and you manipulate Decimal fields (Access DataType=Number/FieldSize=Decimal, or SQL DataType=Decimal) using DAO (Data Access Objects), you might have identified your app crashing.

If you hover a variable with the type in VBA code, you may see that the field is not being displayed properly; either reading as ????? or giving a Type Mismatch error, or Access may crash.

WARNING: A fix for this issue will be delivered soon. It currently only affects Current Channel, Beta and Insiders versions. For more information, visit Decimal Field Problems in Microsoft Access Build 12827.20010.

Monthly Enterprise Channel
May 12, 2020

Version 2003 (12624.20588)

This update features the following:
  • Be more productive working in Query Designer, SQL view, and the Relationships window: Right-click a table to open, design, size, and hide it. Search and replace text in SQL View. Select multiple tables in the Relationships window.

Current Channel
Apr 29, 2020

Version 2004 (12730.20236)

This update features the following:
  • Be more productive working in Query Designer, SQL view, and the Relationships window: Right-click a table to open, design, size, and hide it. Search and replace text in SQL View. Select multiple tables in the Relationships window.
  • Add Tables Task Pane: Use the Add Tables task pane, which stays open while you work, to add tables to relationships and queries with fewer clicks.

Semi-Annual Enterprise Channel (Preview)
Mar 24, 2020

Current Channel
Mar 24, 2020

Monthly Enterprise Channel
Mar 24, 2020

Version 2002 (12527.20278)



Version 2003 (12624.20176)

Version 2004 (12705.10000)

If you have both Office 365 and an earlier version of Office installed with MSI and you have a program that uses the OLEDB interfaces or the ADO.Net interfaces, you may encounter an error indicating that the database remains locked even after closing the connection.

For more information, visit Office Error: ACCDB remains locked after OLEDB connections is closed.

Semi-Annual Enterprise Channel (Preview)
Mar 10, 2020

Version 2002 (12527.20278)

This feature update has the following:
  • Manage Linked Tables: A central location for viewing and managing all data sources and linked tables in an Access database.

Current Channel
Feb 11, 2020

Version 2001 (12430.20264)

This update fixes the following:
  • Access templates should no longer cause attachment columns to fail within a database. After instantiating a template, you should now be able to add an attachment field to your database.

Current Channel
Jan 30, 2020

Version 2001 (12430.20184)

This update fixes the following:
  • Using an ADODO.Recorder object in VB code may incorrectly report an error.
  • Microsoft Access to fail to identify an Identity Column in a linked SQL Server table, which can cause rows to be reported as deleted incorrectly.

Current Channel
Jan 22, 2020

Version 1912 (12325.20344)

This update fixes an issue that can cause Microsoft Access to fail to identify an Identity Column in a linked SQL Server table, which can cause rows to be reported as deleted incorrectly.

For more information, see Access does not recognize the Identity Column in a linked SQL Server table.

Semi-Annual Enterprise Channel
Jan 14, 2020

Version 1908 (11929.20562)

This feature update has the following:
  • Keep tabs on your database objects: Clearly see the active tab, easily drag tabs to rearrange them and close database objects with just one click.
  • Switch seamlessly: The new account manager shows all of your Office 365 work and personal accounts in one place. Switching between them has never been easier.
  • Zoom with more room: Make the Zoom box bigger, change the font and Zoom remembers it all.

Semi-Annual Enterprise Channel (Preview)
Dec 10, 2019

Version 1908 (11929.20516)

This update fixed the following issues:
  • Fixed an issue where a Union Query that includes references to remote tables (e.g. SQL Server tables) may cause Access to close and restart.
  • Fixed an issue where aggregate like Sum may truncate the result to an integer value.

Current Channel
Dec 3, 2019

Version 1911 (12228.20332)

This update fixed an issue in Microsoft Access that may cause the error "Query is Corrupt" when an Update Query is run, or an UPDATE statement is used in SQL.

Current Channel
Nov 18, 2019

Semi-Annual Enterprise Channel (Preview)
Nov 22, 2019

Semi-Annual Enterprise Channel
Nov 22, 2019

Semi-Annual Enterprise Channel
Nov 22, 2019

Version 1910 (12130.20390)

Version 1908 (11929.20494)



Version 1902 (11328.20480)


Version 1808 (10730.20422)

This update fixed an issue where running an Update query would incorrectly give an error message: "Query is Corrupt".

For more information, see Access Error: "Query is Corrupt".

Security Update
Nov 12, 2019

BAD!

Versions Affected

1808
1902
1908

When attempting to run an Update query, it may not run and displays the error: "Query 'query name' is corrupt".

WARNING:This Security Update causes a serious problem that will not be fixed until the December update.
See Microsoft Access Query is Corrupt Error 3340 for more information.

Current Channel
Sept 30, 2019

Version 1909 (12026.20264)

This feature update has the following:

Semi-Annual Enterprise Channel
Sept 10, 2019

Semi-Annual Enterprise Channel
Sept 10, 2019

Version 1902 (11328.20420)


Version 1808 (10730.20380)

This non-security update fixed an issue that caused certain queries in Microsoft Access to run more slowly than in previous builds.

Semi-Annual Enterprise Channel (Preview)
Sept 10, 2019

Version 1908 (11929.20300)

This feature update has the following:
  • Zoom with more room: Make the Zoom box bigger, change the font and Zoom remembers it all.
  • Keep tabs on your database objects: Clearly see the active tab, easily drag tabs to rearrange them and close database objects with just one click.
  • Switch seamlessly: The new account manager shows all of your Office 365 work and personal accounts in one place. Switching between them has never been easier.

Semi-Annual Enterprise Channel
July 9, 2019

Version 1902 (11328.20368)

This feature update has the following:
  • Refresh, relink or remove linked tables: The updated Link Table Manager is the location for managing all data sources and linked tables.
  • Paint it black, paint it gray: Change the look of Access as often as you like. Four themes to choose from: Colorful, Dark Gray, Black or White.
  • Office has a new look: Office apps now have modern icons that are simpler and more accessible, and the ribbon has updated visuals that highlight the rich collaboration features available in Office apps.

Current Channel
May 29, 2019

Version 1905 (11629.20196)

This feature update has the following:
  • Switch seamlessly: The new account manager shows all of your Office 365 work and personal accounts in one place. Switching between them has never been easier.

Semi-Annual Enterprise Channel (Preview)
Mar 12, 2019

Version 1902 (11328.20158)

This feature update has the following:
  • Refresh, relink or remove linked tables: The updated Link Table Manager is the location for managing all data sources and linked tables.
  • Paint it black, paint it gray: Change the look of Access as often as you like. Four themes to choose from: Colorful, Dark Gray, Black or White.
  • Office has a new look: Office apps now have modern icons that are simpler and more accessible, and the ribbon has updated visuals that highlight the rich collaboration features available in Office apps.

Current Channel
Mar 4, 2019

Version 1902 (11328.20146)

This feature update has the following:
  • Keep tabs on your database objects: Clearly see the active tab, easily drag tabs to rearrange them and close database objects with just one click.
  • Zoom with more room: Make the Zoom bigger, change the font and Zoom remembers it all.

Semi-Annual Enterprise Channel
Feb 12, 2019

Semi-Annual Enterprise Channel
Feb 12, 2019

Version 1808 (10730.20280)


Version 1803 (9126.2356)

This non-security update adds support for new Japanese eras to Access.

Semi-Annual Enterprise Channel
Jan 8, 2019

Version 1808 (10730.20264)

This feature update has the following:

RTM

Sept 24, 2018

Microsoft Page
16.0.10827.20118
What's new in Access 2019?
  • Visualize Data with New Charts.
  • Large Number Support and Support for dBASE is back.
  • Property Sheet Sorting.
  • New Label Name property for controls.
  • ODBC connection retry logic.
  • Tell Me box and Navigation Pane scrolling improvements.
  • Objects in design windows easier to resize
  • Requires Windows 10.

Microsoft Access 2016Note that Access 2016 has two different versions depending on whether it's installed on disk (perpetual license) or Office 365 subscriptions. Office 365 offers continuous updates that occur automatically monthly or every six months depending on your settings. For more information, visit these Microsoft Access pages:

This list is for the perpetual license updates that you download and manually apply.

Date Release Type Reference Build Description
Apr 14, 2020 Security Update KB4484167 16.0.4993.1001

This security update fixed the following issue:

  • A remote code execution vulnerability exists when Microsoft Office improperly loads arbitrary type libraries.
Jan 23, 2020 Update Version 1912 12325.20344

This update fixes an issue that can cause Microsoft Access to fail to identify an Identity Column in a linked SQL Server table, which can cause rows to be reported as deleted incorrectly.

For more information, see Access does not recognize the Identity Column in a linked SQL Server table.

Nov 18, 2019 Manual Update KB4484198 16.0.4927.1002

Be aware that this update applies to the Microsoft Installer (.msi)-based edition of Office 2016. It doesn't apply to the Office 2016 Click-to-Run editions, such as Microsoft Office 365 Home.

This update fixes the following issue:

  • After you install update KB3085368 or KB4484113, you may receive the following error message when you try to run an Update query in Microsoft Access: Query "query name" is corrupt.

Nov 12, 2019 Security Update KB4484113
KB3085368
BAD! When attempting to run an Update query, it may not run and displays the error: "Query 'query name' is corrupt".

WARNING:This Security Update causes a serious problem that will not be fixed until the December update.
See Access Error Query is Corrupt for more information.
Nov 5, 2019 Update KB4475539 16.0.4927.1000 This update fixes the following issues:
  • Access crashes when a form ahs code behind the Resize even that references for the Form.Recordset property.
  • Changes to a macro may not be saved if you don't change focus after making a change.
July 2, 2019 Update KB4462237 16.0.4873.1000 This update fixes the following issue:
  • This update fixes the following issue where you may experience crashes in Access 2016 when you open views in non-design mode, such as in Datasheet View, FormView, Layout View and Report View.
July 2, 2019 Office Update KB4464595 16.0.4873.1000 This update fixes the following issue:
  • In certain circumstances, data that's linked to a SharePoint list is displayed as "#Deleted" in Access 2016.
Mar 5, 2019 Update KB4462192 16.0.4822.1000 This update fixes the following issue:
  • When you view a form that contains a modern chart inside a tab control, Access 2016 crashes.
Feb 5, 2019 Update KB4032257 16.0.4810.1000 This update contains the following improvements and fixes:
  • Improvements to enable the new Japanese era when it is available.
  • Fixes an Access 2016 crash issue that occurs when a form that contains a modern chart in a tab control is loaded in an Access database.
July 10, 2018 Update KB4018338 16.0.4717.1000

This security update resolves vulnerabilities in Microsoft Office that could allow remote code execution if a user opens a specially crafted Office file.To learn more about these vulnerabilities, see Microsoft Common Vulnerabilities and Exposures CVE-2018-8312.

May 1, 2018 Office Update KB3203479 16.0.4690.1000 Fixes the following issue:
  • Access 2016 may freeze when you try to connect to a list on a SharePoint site.
Mar 13, 2018 Office Update KB4011665 16.0.4666.1000

This security update resolves vulnerabilities in Microsoft Office that could allow remote code execution if a user opens a specially crafted Office file. To learn more about these vulnerabilities, see Microsoft Common Vulnerabilities and Exposures CVE-2018-0903.

Jan 2, 2018 Update KB4011221 16.0.4639.1002 Fixes the following issues:
  • When you open a password-protected Access runtime application, the Home tab shows in the ribbon while the password dialog is up.
  • Access 2016 may crash when you try to add a lookup column to a related table in the Datasheet view.
Oct 3, 2017 Update KB4011142 16.0.4600.1000

This update improves the translation of Allow Full Menus option for the Danish version of Access 2016.

Sept 5, 2017 Update KB4011032 16.0.4588.1000 Fixes the following issue:
  • You receive an error message when you import data from a SharePoint list while you use the sr-Cyrl-RS language pack.
July 5, 2017 Update KB3191926 16.0.4561.1000 Fixes the following:
  • MSACCESS.EXE continues to run after close if accessibility tool or any application that requests an accessible interface is running.
June 13, 2017 Office Update KB3191944 16.0.4549.1001

Fixes applications that use the Access runtime close unexpectedly when you export a report to PDF.

May 2, 2017 Update KB3178700 16.0.4534.1000

Enable you to import and export data in dBASE.

Mar 7, 2017 Update KB3128054 16.0.4510.1001

Fixes the keyboard support for Office add-ins in the Backstage.

Dec 6, 2016 Update KB3115503 16.0.4471.1000 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.
Aug 2, 2016 Update KB3115142 16.0.4411.1000 Fixes the following issue:
  • Can't set the Field Size property for number fields in Table Design view.
May 3, 2016 Update KB3114966 16.0.4378.1000 Fixes the following issue:
  • When you drag an object from the Navigation pane to the macro designer in Access 2016, Access 2016 crashes.
Apr 5, 2016 Office Update KB3114965 16.0.4366.1000 Fixes the following issue:
  • 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.
Mar 8, 2016 Update KB3114850 16.0.4339.1000 Fixes the following issue:
  • 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' ".
Feb 9, 2016 Update KB3114522 16.0.4339.1000 Fixes the following issues:
  • 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 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."
Dec 8, 2015 Update KB3114379 16.0.4312.1000 Fixes the Microsoft Access 2016 and Invisible Picture Images problem.
Nov 10, 2015 Security Update KB2910978 16.0.4300.1002 This security update contains the following improvements and fixes:
  • VBA Library names aren't updated to reflect Access 2016. This update changes the version number for Access object library.
  • After you copy, paste, or import forms and reports in Access 2016, the color property settings of existing themes are changes.
  • New Sebian locale (sr-latn-rs) is added to replace the exisiting locale (sr-latn-cs).
  • After you set the OverrideDisableAllActiveX Group Policy setting, you can't run the trusted WebBrowser ActiveX control or import wizard in Access 2010 even though you set the DisableAllActiveX Group Policy setting.

    Additionally, you receive the following error message in the import wizard:
    There is no object in this control.

    Note that the "DisableAllActiveX" registry key is located in the following path:
    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\Common\Security
Sept 22, 2015 RTM Microsoft Page 32-bit: 16.0.4229.1024

64-bit: 16.0.4266.1003
What's New in Microsoft Access 2016?
  • Templates get a Modern Look and Feel.
  • Larger "Show Table" Dialog.
  • Export Linked Data Source Information to Excel.
  • Tell Me, New Themes.
  • Access Web App Features coming to SharePoint on-premise Customers
  • Requires Windows 7 SP 1, Server 2008 R2, or later.

Microsoft Access 2013For a list of the changes in features and funtionality in Microsoft 2013, visit this page:

Date Release Type Reference Build Description
Apr 14, 2020 Security Update KB4462210 15.0.5233.1000

This security update fixed the following issue:

  • A remote code execution vulnerability exists when Microsoft Office improperly loads arbitrary type libraries.
Nov 27, 2019 Manual Update KB2965317 15.0.5189.1002 This update fixes the following issue:
  • After you install update KB4484119, you may receive the following error message when you try to run an Update query in Microsoft Access: Query "query name" is corrupt.
Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2013. It doesn't apply to the Office 2013 Click-to-Run editions, such as Microsoft Office 365 Home.
Nov 12, 2019 Security Update KB4484119 BAD! When attempting to run an Update query, it may not run and displays the error: Query "query name" is corrupt.

WARNING:This Security Update causes a serious problem that will not be fixed until the December update.
See Access Error Query is Corrupt for more information.
Aug 6, 2019 Office Update KB4475556 15.0.5157.1000 This update improves translations for all language versions of Office 2013.
Feb 5, 2019 Update KB4032252 15.0.5111.1001 This update makes improvements to enable the new Japanese era when it is available.
July 10, 2018 Update KB4018351 15.0.5049.1000 This security update resolves the following:
  • An attacker can exploit the vulnerability by providing a specially crafted document file designed to exploit the vulnerability and then convince a user to open the document file. The security update addresses the vulnerability by correcting how Microsoft Access handles objects in the memory. To learn more about these vulnerabilities, see Microsoft Access Remote Code Execution Vulnerability CVE-2018-8312.
Note: To apply this security update, you must have the release version of Service Pack 1 for Microsoft Office 2013 installed on the computer.
Mar 18, 2018 Office Update KB4011234 15.0.5015.1000 This security update resolves the following:
  • A remote code execution vulnerability exists in Microsoft Access software when the software fails to properly handle objects in memory. Exploitation of the vulnerability requires that a user open a specially crafted file with an affected version of Microsoft Access. To learn more about these vulnerabilities, see Microsoft Access Remote Code Execution Vulnerability CVE-2018-0903.
Note: To apply this security update, you must have the release version of Service Pack 1 for Microsoft Office 2013 installed on the computer.
Oct 3, 2017 Update KB3172543 15.0.4971.1000 This update improves the translation of the Allow Full Menus option for the Danish version of Access 2013.
Jan 3, 2017 Update KB3118349 15.0.1893.1000 Fixes the following issue:
  • Access 2013 is unable to start if it's installed side by side with Office 2016 applications.
Sept 6, 2016 Update KB3114948 15.0.4859.1000 Fixes the following issue:
  • When you use the Web Browser control on an Access 2013 form, conditional formatting that's applied to other controls may not be applied correctly.
Mar 8, 2016 Update KB3114735 15.0.4805.1000 Fixes the following issue:
  • When you use the Max aggregate function in a query in Access 2013 that has the Polish language enabled, you receive the following error message: "Nie zdefiniowana funkcja 'Maksimum' ".
Jan 12, 2016 Update KB3114505 15.0.4779.1000 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.
Dec 8, 2015 Update KB3114357 15.0.4779.1000 Fixes the following issue:
  • 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.
Nov 10, 2015 Security Update KB3085584 15.0.4771.1000 This security update contains the following fixes:
  • 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.
  • After you set the OverrideDisableAllActiveX Group Policy setting, you can't run the trusted WebBrowser ActiveX control or import wizard in Access 2010 even though you set the DisableAllActiveX Group Policy setting.

    Additionally, you receive the following error message in the import wizard:
    There is no object in this control.

    Note that the "DisableAllActiveX" registry key is located in the following path:
    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\Common\Security
Sept 8, 2015 Update KB3085503 15.0.4749.1000 This update contains the following improvements and fixes:
  • Enables single sign-on (SSO) for ADAL on cloud domain-joined computers. On cloud domain-joined computer that has Modern Authentication enabled, domain accounts seem to be logged in but can't open files.
  • When you try to use the import text wizard to import a text file that contains DBCS characters in Access 2013, the results don't align correctly for newly created columns.
Aug 11, 2015 Update KB3055016 15.0.4745.1000 Fixes the following issue:
  • 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.
July 14, 2015 Update KB3054950 15.0.4737.1000 Fixes the following issues:
  • Opening 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.
June 9, 2015 Update KB3054795 15.0.4723.1000 Fixes the following issue:
  • When you try to split a database by using the Access Database function in Microsoft Access 2103, Microsoft Access Signed Package (.accdc) is the only save type and the Access Database (.accdb) save type is unavailable.
May 12, 2015 Update KB2975869 15.0.4711.1000 Fixes the following issue:
  • 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, Access 2013 crashes.
Apr 14, 2015 Update KB2965276 15.0.4709.1000 Improves translation of some user interface elements in Macedonian to multiple languages to make sure the accuracy of the meanings in Access 2013.
Mar 10, 2015 Update KB2956176 15.0.4701.1001 Fixes the following issues:
  • You may be unable to calculate some fields in Access 2013 if the computer has not been restarted for a long time (24 days, for example).
  • When you open an Access Web App that contains very large data macros in Access 2013, you may receive an 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 in Access 2013, Access may crash.
  • Assume that you create an Access Web App in Access 213. An 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), then set the data type to Image.
    • You add more than 32 new fields and then set the Index properties to Yes (No Duplicates).
    After, in this scenario, when you try to open the saved Web App, the error occurs again.
  • Updates Access 2013 to 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: "Cannont insert object" error in an ActiveX custom Office solution after you install the MS14-082 security update (KB3025036).
Feb 10, 2015 Update KB2910930 15.0.4691.1000 Fixes the following issue:
  • When you click [OK] in the Print dialog box 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.
Nov 11, 2014 Update KB2863859 15.0.4663.1000 Fixes the following issue:
  • 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.
Oct 10, 2014 Hotfix KB2889947 15.0.4659.1000 Issue that this hotfix package fixes:
  • 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.
Apr 8, 2014 Hotfix KB2863871 15.0.4601.1000 Issues that this hotfix package fixes:
  • When you try to set properties of an ActiveX Data Objects (ADO) recordset by using some Visual Basic code in an Access 2013 form, you receive one of the following error messages.
    • Run-Time error '2455'. You entered an expression that has an invalid reference to the property UniqueTable
      The expression <event> you entered as an event property setting produced the following error: "Type Mismatch (Run-Time error 13)".
  • When you try to package an Access Web application, an .app file is not generated and you receive the following error message:
    • An error occurred in the client while attempting to communicate with the server '[URL]'. Please contact your system administrator or technical support.
Feb 25, 2014 SP1 KB2817430 15.0.4569.1506 Microsoft Office 2013 Service Pack 1 (SP1) provides the latest updates for Office 2013. This service pack includes two kinds of fixes:
  • Previously unreleased fixes that are included in this service pack. In addition to general product fixes, these fixes include improvements in stability, performance and security.
  • All the monthly security updates that were released through January 2014 and all the Cumulative Updates that were released through December 2013.
Dec 10, 2013 Update KB2827233 15.0.4551.1006 This update provides the latest fixes for the 32-bit and 64-bit editions of Access 2013. Additionally, this update contains stability and performance improvements.
Dec 10, 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".
Oct 8, 2013 Update KB2768008 15.0.4535.1507 This update provides the latest fixes for the 32-bit and 64-bit editions of Access 2013. Additionally, this update contains stability and performance improvements.
Sept 10, 2013 Update KB2752093 15.0.4535.1000 This update provides the latest fixes for the 32-bit and 64-bit editions of Access 2013. Additionally, this update contains stability and performance improvements.
Feb 12, 2013 Update KB2760350 15.0.4454.1000 This update provides the latest fixes for the 32-bit and 64-bit editions of Access 2013. Additionally, this update contains stability and performance improvements.
Jan 29, 2013 RTM Blog
Free Trial
15.0.4420.1017 What's New in Microsoft Access 2013?
  • 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.

Microsoft Access 2010

For a list of the changes in features and functionality in Microsoft 2010, visit this page:


Date Release Type Reference Build Description
Apr 14, 2020 Security Update KB4464527 14.0.7248.5000

This security update fixed the following issue:

  • A remote code execution vulnerability exists when Microsoft Office improperly loads arbitrary type libraries.
Nov 27, 2019 Manual Update KB2986256 14.0.7241.5001

This update fixes the following issue:

  • After you install update KB4484127, you may receive the following error message when you try to run an Update query in Microsoft Access: Query "query name" is corrupt.

Be aware that this update applies to the Microsoft Installer (.msi)-based edition of Office 2010. It doesn't apply to the Office 2010 Click-to -Run editions, such as Microsoft Office 365 Home.

Nov 12, 2019 Security Update KB4484127 BAD! When attempting to run an Update query, it may not run and displays the error: "Query 'query name' is corrupt".

WARNING:This Security Update causes a serious problem that will not be fixed until the December update.
See Access Error Query is Corrupt for more information.
Mar 5, 2019 Update KB4018363 14.0.7230.5000 This update adds the ability to use the new Japanese era in Access 2010 when it is available.
Note: To enable this improvement, you also need to install KB4461626 and KB2589339 together with this update.
Jan 18, 2019 Update KB4462157 14.0.7228.5001 This fixes the following issues:
Jan 8, 2019 Security Update KB4461614 BAD!

After you install this security update, Microsoft Access 2010 abd Excel 2010 stop working.

To resolve this issue, install January 18, 2019, update for Office 2010 (KB4462157).

Dec 4, 2018 Office Update KB4461579 14.0.7226.5000 This update makes some changes for the Japanese calendar in Office 2010 so that the new Japanese era name can be displayed correctly when a new era begins.Additional updates may be required for Office applications because of expected changes in the Japanese era.
Mar 13, 2018 Office Update KB3114416 14.0.7195.5000 This security update resolves vulnerabilities in Microsoft Office that could allow remote code execution if a user opens a specially crafted Office file. To learn more about these vulnerabilities, see Microsoft Access Remote Code Execution Vulnerability CVE-2018-0903.
Mar 8, 2016 Office Update KB3085515 BAD!

This Office Update is no longer available from the Microsoft Update or the Microsoft Download Center. After you install this update, you may not be able to open Microsoft Visual Basic-enabled apps in Microsoft Access 2010. Also, Access wizards may not run. To work around the problem, uninstall this update by following the steps in the "How to uninstall this update" section.

If you installed it, visit our blog post Microsoft Office 2010 Update KB3085515 Causes Access ACCDE and MDE Databases to Crash.

Nov 10, 2015 Security Update KB3101544 14.0.7162.5001 This security update contains the following fixes:
  • After you set the OverrideDisableAllActiveX Group Policy setting, you can't run the trusted WebBrowser ActiveX control or import wizard in Access 2010 even though you set the DisableAllActiveX Group Policy setting.

    Additionally, you receive the following error message in the import wizard:
    There is no object in this control.

    This issue occurs after you apply the March 10, 2015 update for Access 2010 (KB2837601). The Group Policy setting is set under the following registry key:
    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\Common\Security
Oct 13, 2015 Update KB3055045 14.0.7160.5000 Fixes the following issue:
July 14, 2015 Update KB2965300 14.0.7153.5000 Fixes the following issue:
  • 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.
Mar 10, 2015 Update KB2837601 14.0.7145.5001 Fixes the following issue:
Nov 11, 2014 Hotfix KB2899528 14.0.7137.5000 Fixes the following issue:
  • 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.
Note: To install this hotfix package, you must have Office 2010 Service Pack 2 (SP2) installed.
Sept 10, 2013 Update KB2687423 14.0.7104.5000 This security update resolves the following:
  • Security vulnerabilities in Microsoft Access that could allow remote code execution when a specially crafted Access file is opened.
Aug 13, 2013 Hotfix KB2760760 14.0.7104.5000 Fixes the following issue:
  • 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.
July 22, 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.
May 2013 SP2 KB2687455 14.0.7015.1000 Microsoft Office 2010 Service Pack 2 (SP2) provides the latest updates for Office 2010. This service pack includes two kinds of fixes:
  • Previously unreleased fixes that are included in this service pack. In addition to general product fixes, these fixes include improvements in stability, performance and security.
  • All the public updates that were released through May 2013 and all the cumulative updates that were released through April 2013.
Read our article on the Access updates and issues, Microsoft Access and Office 2010 Service Pack 2 (SP2) Enhancements and Issues.
Apr 9, 2013 Hotfix KB2760805 14.06137.5000 Fixes the following issues:
  • When you import and Excel workbook that contains currency data into Access 2010, the currency data is not imported.
  • Assure that the drivers that are included in Microsoft Office 2010 or Access Database Engine 2010 are installed on a computer. You create an Excel spreadsheet that contains a data connection to an Access database on the computer. When you open the spreadsheet in Microsoft Excel 2007 and then update the data in the spreadsheet, you receive the following error message: "Could not find installable ISAM".

    This issue also occurs if you create the spreadsheet in Excel 2013 and then open the spreadsheet in Excel 2010.
Feb 13, 2012 Office Hotfix KB2640696 ADO 6.6.7601.17761 Assume that you develop an ActiveX Data Objects (ADO)-based data access application on a computer that is running Windows 7 Service Pack 1 (SP1) or Windows Server 2008 R2 Service Pack 1 (SP1). However, the application does not run on a computer that is running an earlier version of Windows. For more information, see An ADO-based application that is compiled in Windows 7 SP1 or in Windows Server 2008 RS SP1 does not run in earlier versions of Windows.

Note:
  • ADO-based applications that are compiled in Windows 7 SP1 or in Windows Server 2008 RS SP1 use the new interface identifiers (IIDS) in the ADO type libraries that were included in the SP1 packages for Windows 7 and for Windows Server 2008 R2.
  • This issue does not occur if the hotfix that is described in the following Microsoft Knowledge Base article is installed on the computer that is running an earlier version of Windows:
June 28, 2011 SP1   14.0.6029.1000 64-bit version changes ACCDE file format and is not backward compatible with RTM.
For more information, see our blog post Microsoft Access 2010 Service Pack 1 VBA Project Compatibility Issues.
Jul 15, 2010 RTM   14.0.1760.1000
(32-bit)

14.0.4760.1000
(64-bit)
What's new in Microsoft Access 2007?
  • Introduced 64-bit version of Access.
  • Access Web Apps using SharePoint Lists.
  • Data Macros for ACCDBs.
  • Dropdown lists for a table can be modified in place.
  • Whenever any table is updated, all reports referencing the table are also updated.
Date Release Type Reference Build Description
Nov 10, 2015 Security Update KB2596614 12.0.6735.5000 This security update contains the following fixes:
  • Resolves vulnerabilities in the 2007 Office suite that could allow remote code execution if a user opens a specially crafted Office file.
Sept 10, 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.
Oct 25, 2011 SP3 KB2526086 12.0.6606.1000 Previously unreleased fixes that were made specifically for this service pack. In addition to general product fixes, this includes improvements in stability, in performance, and in security.
Aug 31, 2010 Hotfix KB2276481 12.0.6542.5000 Fixes the following issues:
  • Access hanging on large attached table when clicking arrow beside date column.
  • Templates disappear (with Spanish MUI on Win XP/2003).
  • Unable to link Sybase database if File DSN contains spaces.
June 10, 2010 Hotfix KB983317 12.0.6539.5000 Fixes the following issue:
  • Errors when importing data using the "Get External Data - Text File" wizard.
Apr 27, 2010 Hotfix KB981049 12.0.6535.5000 Fixes the following issue:
  • ApplyFilter macro does not accept subsequent parameters, and "There isn't enough memory to undo......" error when running 1.5MB query.
Feb 23, 2010 Hotfix KB978402 12.0.6529.5000 Fixes the following issue:
  • Fixes Runtime crash after application of Service Pack 2.
Dec 15, 2009 Hotfix KB977033 12.0.6521.5000 Fixes the following issue:
  • Ribbon options for rich text box now work in subforms.
Oct 27, 2009 Hotfix KB974995 12.0.6520.5000 Fixes the following issues:
  • 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.
Aug 25, 2009 Hotfix KB973405 12.0.6514.5000 Fixes the following issues:
  • Parameter shown as numbers (ASCII Value) instead of text on a report.
  • Store procedure executed multiple times when opening a form/report.
  • Navigation Pane and Status Bar issues after applying Service Pack 2.
  • Caluclated Field changes value while scrolling.
June 30, 2009 Hotfix KB971859 12.0.6510.5000 Fixes the following issues:
  • Query crashing (ODBC, Inheritance and Aggregation).
  • Last Row not imported.
  • Decimal Lookup field not displayed (from ODBC table).
June 30, 2009 Hotfix KB972347 12.0.6510.5000 Fixes the following issue:
  • 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.
June 30, 2009 Hotfix KB972570 12.0.6510.5000 Fixes the following issue:
  • Slow performance when clicking fields, tabbing between fields or scrolling down through fields in Datasheet view.
Apr 29, 2009 Update KB963663 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.
Apr 24, 2009 SP2 KB953195 12.0.6423.1000 Fixes the following issues:
  • Fixes Open Snapshot so that snapshots open more reliably, even if there is no SharePoint root site.
  • Display issues that cause calculations to appear incorrect in some cases.
  • Fixes the Import data wizards, report printing and previewing, macros, Excel integration, and date filters.
  • Fixes conditional formatting in Mozilla Firefox browsers.
Adds the following features:
  • Exports reports to Excel.
  • PDF Exporting feature is now built in.
  • Supports memo fields in the mailing label wizard for addresses.
  • Improves connections to cubes by using .odc files in non-English cases.
  • Improves the performance of programmatic scenarios.
  • Improves support for generating Excel Web Access Web parts on new sites.
  • Recognizes trusted locations set at the machine level.
Oct 3, 2008 Extra 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".
Dec 8, 2007 SP1 KB942378 12.0.6211.1000 Office 2007 SP1 fixes KB936982.
Jun 24, 2007 Hotfix KB939185 12.0.6027.5000 Fixes the following issue:
  • 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.
Apr 27, 2007 Hotfix KB936519 12.0.6019.5000 Fixes the following issue:
  • 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.
Apr 11, 2007 Hotfix KB935875 12.0.6012.5000 Fixes the following issue:
  • 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.
Apr 8, 2007 Hotfix KB935521 12.0.6012.5000 Fixes the following Errors:
  • 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.
  • 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.
Jan 27, 2007 RTM   12.0.4518.1014 What's new in Microsoft Access 2007?
  • 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.
Date Release Type Reference Build Description
Dec 18, 2007 Hotfix KB945674 11.0.8204 Fixes the following issues:
  • Problems with SP3 such as combo box and list box displaying no value or incorrect values.
  • Working with bit fields in SQL Server tables.
  • Prevent unexpected closing.
  • Address problems with ADPs and VSS and other issues.
Sept 18, 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.
Sept 27, 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.
Oct 2004 Tool 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.
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.
Nov 27, 2003 RTM   11.0.5614.0 What's new in Microsoft Access 2003?
  • Windows XP themes.
  • Databases can be created with digital signatures.
  • Explicit database trust to run VBA code.
Date Release Type Build Description
Aug 9, 2005 SP3 10.0.6501
10.0.6771
 
  SP2 10.0.4302  
  SP1 10.0.3409  
May 31, 2001 RTM 10.0.2627.1 What's new in Microsoft Access 2002?
  • XML Support
Date Release Type Reference Build Description
Oct 21, 2002 SP3 KB326605
KB326585
9.0.6926
9.0.6771
Fixed problems upsizing to SQL Server, SendObject, scroll bars, font list, Zoom Builder, OpenReport, etc.
  SP2 KB276257 9.0.4402  
Dec 12, 2000 SR-1/SR-1a KB245025 9.0.3821  
June 7, 1999 RTM   9.0.2720 What's new in Microsoft Access 2000?
  • New MDB Jet format with record locking.
  • ADO and Unicode.
  • Access Data Projects (ADPs) for SQL Server introduced.
  • Shared VBA and VB6 IDE.
Date Release Type Reference Build Description
Oct 1999 SR-2b TechNet
July 11, 1997 SR-1 TechNet 8.0.4122 A new version of the ODBC 3.0 Driver Manager provides enhanced security features for sites requiring heightened controls when using ODBC.
Jan 16, 1997 RTM What's new in Microsoft Access 97?
  • Part of Office 97 Suite.
  • Hyperlinks added.
Date Release Type Description
Aug 24, 1995 RTM What's new in Access 95?
  • Added to Office 95 Professional Suite.
  • Supports ActiveX controls.
  • VBA replaces Access Basic.
  • Requires Windows 95 or later.
Date Release Type Build Description
Nov 1994 SP 2.50.0127
Apr 1994 RTM 2.0 What's new in Microsoft Access 2?
  • Supports Windows 3.1
  • 4 MB RAM Minimum.
Date Release Type Description
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.

Date Release Type Description
Nov 1992 Product Debut First Windows relational database (for Windows 3.0).

Microsoft Access Runtime Distribution and Free Downloads

The Microsoft Access runtime program lets you distribute, royalty-free, your Microsoft Access databases to users who don't own a licensed copy of Microsoft Access.

They install the runtime program and run your database.

Microsoft SQL Server Express

We've compiled a similar comparison of different versions of Microsoft SQL Server Express:

To compile the information on this page, we conducted extensive internal research and are grateful for these references:

Table Design

Query Design

Form Design

Form Tips and Mistakes

Copy Command Button and Keep Picture

Module VBA to Forms and Controls

Form Navigation Caption

Resync Record in a Subform

Synchronize Two Subforms

Multiple OpenArgs Values

Late Bind Tab Subforms

Subform Reference to Control Rather than Field

Tab Page Reference

Shortcut Keys


Combo Box Top 6 Tips

Properties and Validation

Select First Item

Cascading Combo Boxes

Zip, City, State AutoFill

Report Design

Suppress Page Headers and Footers on the First Page of Your Report

Add the NoData Event

Annual Monthly Crosstab Columns

Design Environment

Add Buttons to the Quick Access Toolbar

Collapse the Office Ribbon for more space

VBA Programming

Basics: Forms and Controls

Run VBA Code from a Macro

Use Nz() to Handle Nulls

Avoid Exits in the Body of a Procedure

Shortcut Debugging Keys

Set Module Options

Math Rounding Issues

Rename a File or Folder

Avoid DoEvents in Loops

Age Calculations

Weekday Math

Send Emails with DoCmd.SendObject

Source Code Library

Microsoft Access Modules Library

Microsoft Access Modules

VBA Error Handling

Error Handling and Debugging Techniques

Error Number and Description Reference

Basic Error Handling

Pinpointing the Error Line

Performance Tips

Linked Database

Subdatasheet Name

Visual SourceSafe

Deployment

Runtime Downloads

Simulate Runtime

Prevent Close Box

Disable Design Changes

Broken References

Remote Desktop Connection Setup

Terminal Services and RemoteApp Deployment

Reboot Remote Desktop

Missing Package & Deployment Wizard

Avoid Program Files Folder

Unavailable Mapped Drives

Microsoft Access Front-End Deployment

System Admin

Disaster Recovery Plan

Compact Database

Compact on Close

Database Corruption

Class Not Registered Run-time Error -2147221164

Inconsistent Compile Error

Decompile Database

Bad DLL Calling Convention

Error 3045: Could Not Use

Converting ACCDB to MDB

SQL Server Upsizing

Microsoft Access to SQL Server Upsizing Center

Microsoft Access to SQL Server Upsizing Center

When and How to Upsize Access to SQL Server

SQL Server Express Versions and Downloads

Cloud and Azure

Cloud Implications

MS Access and SQL Azure

Deploying MS Access Linked to SQL Azure

SQL Server Azure Usage and DTU Limits

Visual Studio LightSwitch

LightSwitch Introduction

Comparison Matrix

Additional Resources

Connect with Us

 

Free Product Catalog from FMS