Last Updated 5 May 2022 Difficulty level : Easy
The first version of Access was released 30 years ago in Nov 1992. As I have copies of all versions of Access from 1.0 onwards, I thought it might be interesting to celebrate its 30th anniversary by reviewing the main changes in the appearance and features of Access over the past 30 years . . . as well as looking to the future.
Get ready for a bit of nostalgia as we cover 30 years of Access . . .
NOTE: This is a significantly updated and expanded version of an article originally posted at Access World Forums back in Feb 2019: A Trip Down Memory Lane
Access 1.0 (Nov 1992)
During some unexpected free time early in 2019, I went through some old files and found a long discarded copy of Access 1.0 from 1992.
I decided to install it on a virtual machine as part of my research for my articles about system tables and Access security:
Purpose of System Tables
Access Security By Version
The main Access files are on just 6 floppy disks and that included Northwind together with two other sample databases.
The basic structure of tables/queries/forms/reports/macros & modules was, as you can see, already in place in version 1.
In fact, there are 9 floppy disks in the complete install though I only loaded the first 6 originally.
I've since installed the last 3 disks as well, so I can now in theory connect it to SQL Server (disk #7).
There were several more example databases on disk #8 including 2 x PIMs, Business Forms Sampler, Inventory for Sweets company, Order Entry in addition to the Northwind database.
Disk #9 included support for networking (Windows for Workstations)
Access 1.0 came with a huge amount of other help including 'cue cards' - remember them?
Access 1.1 was a relatively minor update / bug fix released in May 1993
In versions 1.0, 1.1 & 2.0, the programming language was Access Basic with an early version of VBA first added in Access 95.
Versions 1.0, 1.1 & 2.0 all had very poor security with no ability to password protect INDIVIDUAL files or module code (see Security section below)
Access 2.0 (Apr 1994)
This was included as part of Office 4.3
A new version of the Northwind example database was supplied:
Version 2.0 also included the excellent Solutions database as part of the program help:
The main changes in Access 2.0 included:
• Command bars added
• JET database engine updated to v2.0 with related changes to system tables
Access 95 - version 7.0 (Aug 1995)
NOTE: version numbering was aligned with other Office programs
There was another new version of Northwind (needed due to changes in Access file structure):
The main changes in Access 95 included:
• VBA first introduced (version 3.0)
• ActiveX controls added
• JET database engine updated to v3.0
• Password protection for individual MDB files
Access 97 - version 8.0 (Jan 1997)
Access 97 was a large leap forwards and many developers consider it to be the first 'mature' version. It was a very stable and highly regarded version.
By then, VBA included many of the features we know & use today
The main changes in Access 97 included:
• VBA updated to v5.0 with significant changes
• Hyperlink control added
• JET database engine updated to v3.5
• Whole database encoding (AKA encryption) (32-bit)
• Compiled version (MDE format) added
Access 2000 - version 9.0 (Jun 1999)
The main changes in Access 2000 included:
• ActiveX Data Objects (ADO) added
• Record locking & Unicode storage added
• JET database engine updated to v4.0
• VBA updated to v6.0 - again with significant changes
• Access Data Projects (ADP) added - connected to SQL Server
• Smart Tags added
• Visual Source Safe integration
• SQL Server Upsizing wizard added
• Package Solution Wizard added
NOTE: Access 2000 files can still be opened / edited in all versions of Access including the current versions (2021 / 365)
Access 2002 (XP) - version 10.0 (May 2001)
This was a relatively minor update from Access 2000
The main changes in Access 2002 included:
• Conditional formatting added
Access 2003 - version 11.0 (Nov 2003)
This was another very stable version and is still widely in use today
The main changes in Access 2003 included:
• Editing linked Excel files removed (following a copyright infringement case )
• Support for linked Sharepoint lists
• Support for Windows XP themes
• Digital signatures added
Access 2007 - version 12.0 (Jan 2007)
This was a significant update with many changes - not all appreciated by the developer community!
The main changes in Access 2007 included:
• New ACCDB file format
• New ACE database engine v12.0 (replaced JET)
• Runtime version now available as free download
• Ribbon and Quick Access Toolbar (QAT) replaced old menus & command bars
• Navigation pane and tabbed interface added
• Database encryption with password (originally 40-bit - later increased to 128-bit
• New Trust Center including the use of Trusted locations
• TempVars added
• Removed user level (workgroup) security & replication from ACCDB files
• Added attachment, multivalued fields & memo field column history
• Added rich text to memo fields
• Added saved import / export specifications
• Removed Data Access Pages (DAP)
• Added Data Collection emails
• Reports - added report view and PDF output (via a separate plug-in)
• Added alternating row colours in forms / reports
• Added split forms
• New image & web browser controls
• Added date picker
• Datasheet improvements: filtering & totals
• Added buttons with both text & image
• Form anchoring and layout guides
Yet another updated version of Northwind was supplied to 'showcase' many of these new features
However this version of Northwind has been heavily criticized over the past 15 years both for its poor design and bad database practice.
Access 2010 - version 14.0 (Jul 2010) NOTE: version 13 was skipped!
The main changes in Access 2010 included:
• 64-bit version available as well as 32-bit
• Updated to VBA7 to support 64-bit Access
• New macro builder
• Data macros added
• Navigation forms added
• Image gallery added (shared images)
• Themes & application parts added
• Access web databases (based on Sharepoint lists)
• Support for dBase, Paradox & Lotus 123 rables all removed
• New backstage view (File tab)
• Improvements to report & layout view
• Improvements to report sorting & grouping
• Embedded macros added
• Calculated fields added
• New database templates
Access 2013 - version 15.0 (Feb 2013)
This version was notable for the large number of features removed without a viable replacement
The main changes in Access 2013 included:
• New click to run installation introduced
• Office web components (Pivot tables & charts) no longer supported
• dBase support removed
• Creating Access Data Collection no longer supported
• Smart tags no longer supported
• Access 2003 toolbars & menus only available in ribbon / add-in tab
• MDB replication options no longer available
• Visual source safe control no longer available
• SQL Server upsizing and package solution wizards removed
• Three state workflow entry points removed
• Sandboxed ACE engine
• Access web apps (based on SQL Server)
• Access Data Projects (ADP) no longer supported
• Opening Access 97 (JET 3.x) files no longer supported
Access 2016 (Sep 2015) / 2019 (Sept 2018) / 2021 (Oct 2021) / 365 (monthly updates) - ALL version 16.0
All versions since 2016 share almost all code and all are listed as version 16.0
365 is a subscription model with monthly updates, the others are retail versions which only get security updates
The main changes in Access 2016 onwards include:
• New Salesforce and Dynamics data connectors (Access 2019 onwards)
• dBase table support restored (Access 2019 onwards)
• Support for SQL Server bigint datatype (Access 2019 onwards)
• ODBC comnnection retry logic added (Access 2019 onwards)
• Accessibility improvements (Access 2019 onwards)
• New date/time extended datatype (Access 2021/365)
• New 'modern' charts (Access 2019 onwards)
• Alphabetical sorting of property sheet (Access 2019 onwards)
• Enhanced zoombox (Access 2019 onwards)
• Improvements to query designer, SQL & relationships views (Access 2021 onwards)
• Dark themes added (Access 2021 onwards)
• Active tab highlighted (Access 2021 onwards)
• Add tables task pane (Access 2021 onwards)
• Access web apps deprecated
• New 'streamlined' ribbon (Access 365)
• Improved linked table manager (Access 2021 & 365)
|Old Linked Table Manager (up to Access 2019)
||New Linked Table Manager (Access 2021 onwards)
The Northwind Database
As mentioned above, there have been at least 5 versions of the Northwind example databases over the years, starting with Access 1.0 in 1992, with a completely new version created for Access 2007.
There have also been several changes to the photos supplied for the fictitious Northwind employees such as Nancy Davolio:
|Access 1.0 (1992)
Although progress remains frustratingly slow, Access is still being actively developed despite the widespread, but incorrect, rumours that Microsoft plans to discontinue it!
However, for the past two years ALL development activity has been entirely focused on the new Dataverse connector to the frustration of the Access community as a whole.
The Access team is currently working on the following items:
• Dataverse connector (due for final release June 2022)
• Fixing the inconsistent database error (AKA 'monster bug') - after ONLY 4 years!
• New web browser control based on Chromium Edge
• Enable Large Address Awareness for 32-bit Access
• New Monaco SQL editor - as used in Visual Studio
• New Microsoft Graph Data connector
For the latest updates, see the Microsoft 365 Access Roadmap
NOTE: The target dates on the Access roadmap are incorrect and should largely be ignored!
It is also planned to focus on improving the reliability of Access updates which have been plagued by a series of 'update bugs' in recent months.
Several serious bugs have occurred, badly affecting the work of developers, system admins and end users as well as damaging public confidence in Access.
In addition, a new version of the Northwind example database is currently being developed as a community project - the first update since Access 2007!
Access Security By Version
Access security was very weak in all MDB versions up to 2003 but was significantly improved with the introduction of the new ACCDB file format and database encryption in version 2007
The summary below is taken from my article: Access Security By Version
Further Reading: Microsoft Access Version Features and Differences Comparison Matrix
I would be very grateful for any feedback on this article including any errors or omissions.
Please use the feeback form below to contact me. Many thanks!
Colin Riddington Mendip Data Systems Last Updated 5 May 2022
Return to Access Articles Page
Return to Top