Limitations of the Access 2007 Database
Microsoft Access 2007 is database software used to store, retrieve and create detailed reports. The software comes with several limitations, including actual application limitations (such as memory and file size), report size limitations and character or parameter limitations for certain Access functions. For example, the criteria in the query function of Access may be limited to a certain amount of characters (letters, punctuation or symbols).
Other People Are Reading
-
Database Application
-
Only 32,768 objects can exist in one database at a time, which includes forms, queries, tables, reports, macros, modules, indices and any other internal objects used by Access. Object names can only contain a maximum of 64 characters. Open tables in Access are limited to 2048, which also includes linked tables. Users who work with Access on networked computers, or share the software, can only create user name/group names with a maximum of 20 characters and are limited to 14 characters in a password. A single database file size cannot exceed two gigabytes, but a split database (such as using front-line databases linking to back-end databases) could counter this limitation.
Query
-
Users can only query a maximum of 34 tables. The query can only return 225 fields in a record set, and the record-set memory size must not exceed the maximum memory size of one gigabyte. Queries are limited to a sort list of 225 characters in one or more fields and parameterized queries are also limited to 255 characters. In a "where" or "having" clause, only 99 "and" operators can be used, and a SQL statement is limited to 64,000 characters. However, if multivalued look-up fields are included in the query, the character limit for clauses and SQL statements may be less
-
Form and Report View
-
Forms and reports created from a query can only be 22 inches (55.87 centimeters) wide by 22 inches in height, with only one header, one footer, or 10 group headers and footers. Labels in forms and reports are limited to 2,048 characters, and characters in a text box cannot exceed 65,535. Both reports and forms are limited to 65,536 pages per report, with a limit of 754 controls and sections added to the document of its lifetime. A maximum of 10 fields or expressions can be sorted or grouped in one report.
Macros and Project Specifications
-
Actions in a macro are limited to 99 actions per macro, with a limit of 255 characters in a condition, comment or action argument. Access 2007 projects (.adp files) are limited to 32,768 objects per project, 1,000 modules, 64 characters in an object name, and 250 columns in a Microsoft SQL Server 6.5 file -- or 1,024 in Microsoft SQL Server version 7.0, version 2000 and version 2005. Access 2007 project limitations for forms, reports and macros are the same as limitations for regular Access files and database applications.
-
