Determining The Table Specification In Access 2010

In this article I am going to explain Determining the table specification In Access 2010.
  • 2149

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.