How Much Data Can Access Hold?
Access is Microsoft's desktop database application. Although it is a desktop application, up to 255 concurrent users can use it if there are sufficient network and personal computer resources.
Other People Are Reading
-
Fields
-
Access restricts field names to 64 characters. There is a maximum of 255 fields per table. Text fields can store 255 characters of data. Memo fields can store up to 65, 535 characters of data if it is entered within Access. If you enter the data programmatically, however, then there is 2 gigabytes of character storage per memo field. OLE Object files can store 1 gigabyte of data. Field descriptions and field property settings are limited to 255 characters.
Tables
-
Access also limits table names to 64 characters. Tables can contain up to 2 gigabytes of data, excluding the space that is needed for system objects. You can open 2,048 tables if you have sufficient computer memory and processing power. A table can have as many as 32 indexes with a maximum of 10 fields in an index.
-
Database
-
An Access database is limited to 2 gigabytes of storage in a single database. If you use a split database, however, you can connect to thousands of database files on a network share with only the front-end database loaded on your computer.
-
References
Resources
- Photo Credit data disk image by sumos from Fotolia.com
