Microsoft Access 2010 Maximum Limits and Specifications
Applies to: Microsoft® Access® 2010 Windows (Desktop)
Below is a list of Microsoft Access 2006 maximum limits and specifications.
You may also want to check out key new features in our related overviews:
Looking for Microsoft Access training courses?
Access Database and Objects Maximum Limits and Specifications
Total size for an Access 2010 database (.accdb), including all database objects and data: 2 gigabytes, minus the space needed for system objects. You can work around this size limitation by linking to tables in other Access databases. You can 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: 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field: 255 characters
Number of characters in a Memo field: 65,535 characters when entering data through the user interface;
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 Memo 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: 32 relationships 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* AND operators
Number of characters in an SQL statement: Approximately 64,000* characters
*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: 1 report header/footer, 1 page header/footer, 10 group headers/footers
Number of printed pages in a report: 65,536 printed 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 (both .accdb and .adp): 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
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at email@example.com if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
LIve or virtual classroom training
You may like
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You can create calculated fields in select queries in Microsoft Access in the QBE (Query by Example) grid. You'll need to learn a few syntax rules and then you can create simple to more complex calculations.
Check out these great shortcuts for manipulating controls in Design View in both forms and reports in Microsoft Access.
In Microsoft Access, small green error markers may appear in Design View in forms and reports for a number of reasons. You can turn error checking off completely or set the rules you prefer.
You may also like
You can combine first and last name in Excel in several ways – using the CONCATENATE operator, the CONCATENATE function, the CONCAT function, the TEXTJOIN function or Flash Fill. These functions are often used to combine text in cells but you can also combine text with spaces, commas, dashes or another character. It's common to combine first and last names that appear in two columns into one new column. Some functions are only available in newer versions of Excel but the CONCATENATE operator and function are available in all versions.
You can quickly insert multiple columns in Excel using a drop-down menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple columns at once, rather than one by one, is to select the number of columns you want to insert first and then insert columns. Excel will insert the same number of columns you selected.
The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.
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 |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at firstname.lastname@example.org