Determining The Table Specification In Access 2010
In this article I am going to explain Determining the table specification In Access 2010.
Table Specifications
In Access 2010, a table has the following practical limits.
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, this limit includes tables opened internally by Access |
Table size |
2 gigabytes, minus the space needed for the system objects |
Number of characters in a Text field |
255 |
Number of characters in a Memo field |
65,535 when entering data through the user interface,
2 gigabytes of character storage 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 |
2,048 |
Number of characters in a table or field description |
255 |
Number of characters in a record when Unicode Compression property of the fields is set to Yes |
4,000 |
Number of characters in a field property setting |
255 |
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here