Access Capacity Limits

[mls61]

What are the capacity limits for Access? How many gigabites? In addition, is there a max number of rows or columns?

 

[Cbrine]

Do a help serach on Access Specifications. Here's the database limitations, but others are listed as well.

Attribute Maximum
Microsoft Access database (.mdb) (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) file size 2 gigabytes minus the space needed for system objects (system object: Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.).
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

Table Limits
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255

 

[mls61]

Thank you!