Okay, does anyone know what the maximum capacity of a MS Access database like how many records exactly can be entered in each table? is there a max amount?
Printable View
Okay, does anyone know what the maximum capacity of a MS Access database like how many records exactly can be entered in each table? is there a max amount?
A google search turns up this.Quote:
Originally Posted by anthony_pacitto3
:wave:
Here are some more interesting statistics for your information:
Attribute - Maximum
-----------------------------------------
Number of characters in a table name: 64
Number of characters in a field name: 64
Number of fields in a table: 255
Number of open tables: 2048 - Actual max is less, since access opens some by default
Table size: 1 gigabyte
Number of characters in a Text field: 255
Number of characters in a Memo field: 65,535 when entering data through user interface; 1 gigabyte when entering data programmatically.
Size of an OLE Object field: 1 gigabyte
Number of indexes in a table: 32
Number of fields in an index: 10
Number of characters in a validation message: 255
Number of characters in a validation rule: 2048
Number of characters in a table or field description: 255
Number of characters in a record (excluding Memo and OLE Object fields): 2000
Number of characters in a field property setting: 255
Edit: Also and interesting read:
http://databases.aspfaq.com/database...ms-access.html
Thread moved to Database Development forum
In addition to what has been posted above, be aware that the database will almost certainly become unreliable (needing a regular compact & repair etc) long before you reach the 2GB size limit, especially if you have multiple users connected at the same time.
There is more info (including alternatives) in the article Which database system should I use? from our Database Development FAQs/Tutorials (at the top of the Database Development forum)