Access 2016 Key

What is included in Microsoft Access 2016?

Access 2016 desktop – Builds .accdb relational databases on a Windows PC.
Tables and queries – Store, join and filter structured business records.
Forms and reports – Data entry screens and printable report layouts.
External data links – Connect SQL Server, Excel, SharePoint and ODBC.
Core Capacity – 2 GB maximum size per .accdb file.
Important – This is a standalone application; the full Microsoft Office suite is not included.

Compare included Office programs from 2010 to 2024
To compare included applications, read our overview:

What are the main benefits of Microsoft Access 2016?

Microsoft Access 2016 is the standalone desktop database program from the Office 2016 generation, used to build .accdb applications with tables, queries, forms, reports and VBA on Windows. It is a locally installed, one-time-purchase program, and Microsoft ended support for it on 14 October 2025.

Single-app purchase – Database work without buying the full suite.
Local .accdb files – Data stays on your own drive.
Linked Table Manager – Exports every linked data source into Excel.
dBASE file support – Import, link and export .dbf files.
VBA and macros – Automate forms, reports and repeat data tasks.
Split database design – Shared back end, local front-end copies.

Compare Office versions from 2010 to 2024
For help choosing the right Office version, read our guide:

What does Microsoft Access 2016 actually do in daily work?

It converts a shared-spreadsheet workflow into a structured relational database: tables hold the data, queries filter and join it, forms control entry, and reports produce the printed output. The practical gain over an Excel workbook that several people edit is enforcement – field types, required values and table relationships mean an order line cannot reference a customer record that does not exist. Access 2016 allows up to 255 fields and 32 indexes per table, which is well above what a typical departmental application needs. The Linked Table Manager in Access 2016 can also export a full list of every linked data source to Excel, which is the fastest way to document an inherited database before changing anything in it.

Who is Microsoft Access 2016 best suited for?

It fits users who already run an Access 2016 .accdb application and need a matching installation, for example when replacing a workstation or adding a second machine to an existing project. Version matching matters here: a database saved with newer field types such as Large Number (BigInt) or Date/Time Extended can return a "requires a newer version of Microsoft Access" message, and keeping one version across a team removes that whole class of support ticket. It also suits people who need the database application only and have no use for Word, Excel or PowerPoint, since the standalone product installs Access by itself. For a brand-new database project, Access 2021 or Access LTSC 2024 is the better starting point, because Access 2016 no longer receives updates from Microsoft.

How does Access 2016 compare to Access 2019, 2021 and 2024?

All four are perpetual desktop versions built on the same .accdb file format, so the differences are added features and support status rather than a different database engine. Access 2019 introduced the Large Number (BigInt) data type and the modern chart controls (column, line, bar, pie and combo); Access 2021 added the Date/Time Extended data type and the Add Tables task pane; Access 2024 added the Edge-based Browser Control for showing a web page on a form. On Access 2016 the Large Number situation depends on the installed build, since BigInt support arrived during the 2016 lifecycle rather than at launch – older 2016 installations can still refuse a database that uses it.

Which data sources and file formats does Access 2016 support?

Access 2016 stores data in the .accdb format and also opens .mdb files created by Access 2000 and Access 2002-2003. For external data it links to or imports from SQL Server and Azure SQL, other Access databases, Excel workbooks, text and XML files, SharePoint lists and any ODBC data source. dBASE (.dbf) import, link and export returned in the Access 2016 generation, but on MSI-based Office 2016 installations it only appears after two May 2017 updates are applied in order – KB3115501 for Office 2016, then KB3178700 for Access 2016 – while Click-to-Run installations get it automatically. In most production setups the practical pattern is to keep the tables in SQL Server and use Access purely as the forms-and-reports front end, which sidesteps the file-size ceiling described below.

What technical limits and missing features should buyers know about?

The hard ceiling is 2 GB per .accdb file, and that figure covers tables, queries, forms, reports and system objects together, not just the data. The documented maximum is 255 concurrent users, although shared write-heavy databases are normally kept far below that number to reduce corruption risk on a busy network share. Access web apps – the SharePoint-hosted format that the Access 2016 generation could still create – were shut down in April 2018, so that path no longer exists even though traces of it remain in the interface. There is no macOS version of Access in any generation, and this release has no Copilot features and no cloud co-authoring; it is also a standalone application, so Word, Excel and PowerPoint are not part of the product.

Does Microsoft Access 2016 still receive updates from Microsoft?

No. Access 2016 reached the end of its extended support on 14 October 2025, together with the rest of the Office 2016 family, which means no further security updates, bug fixes or Microsoft technical assistance. The software itself keeps working – existing .accdb databases open and run exactly as before – but anything discovered after that date stays unpatched. Access 2019 ended on the same day, while Access 2021 runs to 13 October 2026 and Access LTSC 2024 continues into 2029. That makes Access 2016 a sensible pick mainly for matching an existing installed base, and a poor pick as the foundation of a new long-term deployment.

Does Microsoft Access still have a future?
For more context about Access and Office Pro Plus, read our article:

What should users check before choosing Access 2016?

First, check which Access version created the databases you need to open, because a file containing Large Number or Date/Time Extended fields may refuse to open until those fields are converted back and the matching options are switched off. Second, confirm the bitness: a 32-bit or 64-bit Access installation has to match the ODBC drivers and any third-party add-ins the database relies on, or linked tables will fail to connect. Third, decide whether the 2 GB per-file limit is realistic for the data volume, or whether the tables belong in SQL Server with Access acting only as the front end. Finally, confirm that your Windows version is a supported pairing for the Office 2016 generation before you install.

Check Windows compatibility for Office versions
To check whether your Windows version fits, read our overview:

Frequently asked questions about Microsoft Access 2016

Does Microsoft Access 2016 include Word, Excel or PowerPoint?

No. This is the Access database application on its own – Word, Excel, PowerPoint and Outlook are not part of it. Access can still import, link to and export Excel worksheets, but Excel itself has to be obtained separately.

Does Access 2016 require an existing Office installation?

No. The standalone product installs Microsoft Access by itself and does not need another Office application present to run. If Office is already installed on the machine, it is worth checking how it was installed first, since combining different Office installation technologies on one PC is a frequent source of setup errors.

How does Access 2016 differ from the Access in a Microsoft 365 plan?

Access 2016 is a fixed desktop version, while the Microsoft 365 version continues to receive feature updates. Everything added after this release – Large Number, Date/Time Extended, the modern chart controls, the Add Tables task pane and the Edge Browser Control – is absent here. Both write the same .accdb format, so databases move between them as long as those newer field types are not used.

Can Access 2016 open older .mdb database files?

Yes for Access 2000 and Access 2002-2003 .mdb files, which open directly and can be saved to .accdb. Databases still in the Access 97 format cannot be opened and have to be converted with an older Access version first. Converting to .accdb is usually worth the effort, since attachment fields and multivalued fields only exist in the newer format.

Is Microsoft Access available for macOS?

No. Access is a Windows-only application and has never been part of the Office for Mac suites. Mac users who need to work with .accdb data normally run Access inside a Windows virtual machine or move the tables to SQL Server.