Microsoft Access 2010 Bible

Appendix A: Access 2010 Specifications ...................................................................................

1247

Microsoft Access Database Specifications

TABLE A.1

Databases

Attribute Maximum

.accdb or .mdb file size, including all database

objects and data

2GB, minus space needed for system objects

(Because your database can include attached tables

in multiple files, its total size is limited only by avail-

able storage capacity.)

Total number of objects in a database (tables, que-

ries, forms, reports, and so on)

32,768

Number of modules, including modules attached to

forms and reports

1,000

Number of characters in object names 64

Number of characters in a database password 14

Number of characters in a user name or group name 20

Number of concurrent users 255

TABLE A.2

Tables

Attribute Maximum

Number of characters in a table name 64

Number of characters in a field name 64

Number of fields in a record or table 255

Number of open tables 2,048, including system tables opened by Microsoft

Access internally. Also includes linked tables.

Table size 2GB (minus space needed for system objects). There

is no set limit on the number of rows in an Access

table.

Number of characters in a Text field 255

Number of characters in a Memo field 65,535 when entering data through the user inter-

face; 1GB when entering data programmatically

Size of OLE object field 1GB

Number of indexes in a record or table (including

composite indexes, primary key indexes, and other

indexes)

32, including single-field and composite indexes,

and indexes created internally for maintaining table

relationships

continued

49_475348-bapp01.indd 124749_475348-bapp01.indd 1247 4/1/10 2:01 PM4/1/10 2:01 PM