For those looking to store and manage data in a user-friendly database management system, a free download of Microsoft Access 2010 Runtime (64-bit) for Windows will get you started on the right foot. This software is Microsoft’s answer to the demand for storing large sets of data in a database management system. However, this version is free to download and use since it’s a runtime version primarily designed to run applications from Access. It doesn’t have full support for all the tools and filters you would otherwise expect from the full version of Microsoft Access. While you can open and browse databases, you cannot create or edit in the same capacity as you would with the complete version. 

Features and integrations – What is Microsoft Access, and how is the runtime version unique?

Microsoft Access is designed to have a back-end and a front-end of the database management system. The back end is where the programmer or creator of the database can set up everything they want to implement. This can include everything from sales numbers and percentages to important dates and notes. The front end is the forward-facing side of the database, which users can view with a cleaner interface and more straightforward editing options. The back end is the only place where major changes can be made to the database, while the front end is generally only set up to input simpler pieces of information or choose between table options.  

You might be wondering where the “runtime” version comes into play. Microsoft offers free runtime versions of Access that let users run Access desktop applications without buying or installing the full version of Access. This means developers can create Access databases and share them with as many people as they want without those users needing to pay for Access. You can download the runtime versions for Access 2007 and later for free from Microsoft. For Access 2003 and earlier, the runtime was part of the Office Developer Extensions/Toolkit, which required a separate purchase.

The runtime version allows users to do most of the basics: view, edit, and delete data, as well as run queries, forms, reports, macros, and VBA code. However, it doesn’t let users modify the design of tables, queries, forms, reports, macros, or code. Essentially, the runtime is like a "read-only" version of Access with some added functionality for interacting with the data.

These runtime versions usually work with databases created in earlier versions of Access. For example, Access Runtime 2010 can run applications built in Access 2010, 2007, or even 2000. However, Access 2013's runtime has limited compatibility with older features because certain tools are removed in that version.

If you're developing a database in the full version of Access, you can test how it will work in the runtime environment by using the /runtime command-line option. This lets you ensure your application works smoothly for runtime users.

Compatibility and system requirements – How do I run this on my computer?

Because this is an older version of Microsoft Access and a runtime version of the program, it works best on Windows Server, whether Windows Server 2003, Windows Server 2008, or Windows Server 2012. However, it can also run on more recent versions of Windows because it’s a relatively simple app.

Can I find this version of Microsoft Access through a Microsoft 365 subscription?

While you cannot find this particular version of Microsoft Access on Microsoft 365, the reasoning is simple – you can download Microsoft Access 2010 Runtime (64-bit) for Windows for free, so there’s no reason to pay for it via subscription. However, if you’re looking into Microsoft Access, you might be interested in the full version, which you can find in several subscription plans.

Personal and Family Plans:

• Microsoft 365 Personal: Designed for individual users, this plan includes core Office apps (Word, Excel, PowerPoint, Outlook, Publisher) and 1TB of OneDrive storage. Microsoft Access is included.
• Microsoft 365 Family: Supports up to six users and offers the same features as the Personal plan. Microsoft Access is included.

Business Plans:

• Microsoft 365 Business Basic: Focused on collaboration tools like Teams and online versions of Office apps. Desktop versions are not included. Microsoft Access is not included.
• Microsoft 365 Business Standard: Includes all Business Basic features plus desktop versions of Office apps like Word, Excel, and PowerPoint. Microsoft Access is included.
• Microsoft 365 Business Premium: Adds advanced security and device management features to the Standard plan. Microsoft Access is included.
• Microsoft 365 Apps for Business: Designed for businesses that only need Office apps without email or collaboration tools. Microsoft Access is included.

Enterprise Plans (designed for large companies or universities to provide licenses to their staff or students):

• Microsoft 365 E1: Provides web and mobile versions of Office apps along with Teams and SharePoint. Microsoft Access is not included.
• Microsoft 365 E3: Includes desktop apps, enhanced security, and compliance tools. Microsoft Access is included.
• Microsoft 365 E5: Adds advanced analytics and security features to E3. Microsoft Access is included.
• Microsoft 365 Apps for Enterprise: Focused solely on Office apps without additional enterprise services. Microsoft Access is included.

In summary, Microsoft Access is included in most plans offering full desktop apps, such as Business Standard, Business Premium, and all enterprise plans starting from E3. It is excluded from basic and web-only plans like Business Basic and E1.