Home

Search

or browse popular tags

Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Syndicate

Latest Tutorials

Home / SQL

Microsoft Access Specifications and Limitations

Just as any application, MS Access has specifications and limitations that should be remembered. The following tables specify the maximum sizes and numbers of various objects defined in Microsoft Access databases.

MS Access 1997

Attribute	Maximum
Max mdb file size	1GB
Max objects in database	32768
Max modules in database	1024
Max object name length	64
Max password length	14
Max user/group name length	20
Max users connected to database	255
Max record length (without Memos and BLOBs)	2048
Max fields in table	255
Max nested transactions	7

MS Access 2000

Attribute	Maximum
Max mdb file size	2GB
Max table size	1GB
Max objects in database	32768
Max modules in database	1000
Max object name length	64
Max password length	14
Max user/group name length	20
Max users connected to database	255
Max record length (without Memos and BLOBs)	2048
Max fields in table	255

Tags: ACCESS SPECIFICATIONS LIMITATIONS NUMBER SIZE LENGTH

Add To: dzone | digg | del.icio.us | stumbleupon

Comments
Blog It