Microsoft Access 2016, 2019 and 365 Maximum Limits and Specifications

Applies to: Microsoft® Access® 2016, 2019 and 365 Windows (Desktop)

Below is a list of Microsoft Access 2016 maximum limits and specifications.

You may also want to check out key new features in our related overviews:

Microsoft Access 2016 New Features Overview

Microsoft Access 2013 New Features Overview

Microsoft Access 2010 New Features Overview

Looking for Microsoft Access training courses?

VIEW COURSES AND DATES >

Access Database and Objects Maximum Limits and Specifications

Microsoft Access database: Maximum size of 2 gigabytes (includes all objects minus the space needed for system objects all database objects and data). You can work around this size limitation by linking to tables in other Access databases or link to tables in multiple database files (each of which can be as large as 2GB).

Total number of objects in a database: 32,768 objects

Number of modules (including forms and reports that have the HasModule property set to True): 1,000 modules

Number of characters in an object name: 64 characters

Number of characters in a password: 14 characters

Number of characters in a user name or group name: 20 characters

Number of concurrent users: 255 users

Access Tables Maximum Limits and Specifications

Number of characters in a table name: 64 characters

Number of characters in a field name: 64 characters

Number of fields in a table: 255 fields

Number of open tables: 2,048 tables (including linked tables and the tables opened internally by Access)

Table size: Maximum of 2 gigabytes (minus the space needed for the system objects)

Number of characters in a Text field: 255 characters

Number of characters in a Long Text field: 65,535 characters when entering data through the user interface or 1 gigabyte of character storage when entering data programmatically

Size of an OLE Object field: 1 gigabyte

Number of indexes in a table: 32 indexes including indexes created internally to maintain table relationships, single-field and composite indexes

Number of fields in an index or primary key: 10 fields

Number of characters in a validation message: 255 characters

Number of characters in a validation rule including punctuations and operators: 2,048 characters

Number of characters in a field or table description: 255 characters

Number of characters in a record (excluding Long Text and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes: 4,000 characters

Number of characters in a field property setting: 255 characters

Access Queries Maximum Limits and Specifications

Number of enforced relationships: Maximum of 32 per table (minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships)

Number of tables in a query: 32 tables

Number of joins in a query: 16 joins

Number of fields in a recordset: 255 fields

Recordset size: 1 gigabyte

Sort limit: 255 characters in one or more fields

Number of levels of nested queries: 50 levels

Number of characters in a cell in the query design grid: 1,024 characters

Number of characters for a parameter in a parameter query: 255 characters

Number of AND operators in a WHERE or HAVING clause: 99 operators

Number of characters in an SQL statement: 64,000 characters

NOTE: In queries, maximum values might be lower if the query includes multivalued lookup fields.

Access Forms and Reports Maximum Limits and Specifications

Number of characters in a label: 2,048 characters

Number of characters in a text box: 65,535 characters

Form or report width: 22,75 in. (57.79 cm)

Section height: 22.75 in. (57.79 cm)

Height of all sections plus section headers (in Design view): 200 in. (508 cm)

Number of levels of nested forms or reports: 7 levels

Number of fields or expressions that you can sort or group on in a report: 10 fields or expressions

Number of headers and footers in a report: Limited to 1 report header/footer, 1 page header/footer and 10 group headers/footers

Number of printed pages in a report: 65,536 pages

Number of controls and sections that you can add over the lifetime of the form or report: 754 controls and sections

Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control: 32,750 characters

Access Macros Maximum Limits and Specifications

Number of actions in a macro: 999 actions

Number of characters in a condition: 255 characters

Number of characters in a comment: 255 characters

Number of characters in an action argument: 255 characters

Addiitonal Resources

Microsoft Access 2013 Maximum Limits and Specifications

Microsoft Access 2010 Maximum Limits and Specifications

Microsoft Access DATEADD Function

Related

What is Microsoft Access and What Is It Used For?

How to Convert a Microsoft Access Report to PDF (3 Ways)

10 Techniques for Designing Forms in Microsoft Access

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some live classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom training on a date that's convenient for you.

Microsoft Excel training courses in Toronto. with instructor creating a virtual graph.

You may like

You may also like

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

How to Lock the Position of a Slicer in Excel

How to Lock the Position of a Slicer in Excel

Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you’ll need to select to get this to work.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest