• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. What Every Developer Needs to... > Table Specifications and Limitations

Table Specifications and Limitations

Tables have a number of specifications and limitations as well. Although you will generally not find them restricting, you should keep them in mind. They are listed in Table 2.3:

Table 2.3. Table Specifications and Limitations
ItemLimitation
Number of characters in a table name64
Number of characters in a field name64
Number of fields in a table255
Number of open tables2048; the actual number is less because of tables opened internally by Microsoft Access
Table size2 gigabytes minus the space needed for system objects
Number of characters in a text field255
Number of characters in a memo field65,535 when entering data through the user interface; 1 gigabyte of character storage when entering data programmatically
Size of an OLE Object field1 gigabyte
Number of indexes in a table32
Number of fields in an index10
Number of characters in a validation message255
Number of characters in a validation rule2,048
Number of characters in a table or field description255
Number of characters in a record (excluding Memo and OLE Object fields)2,000
Number of characters in a field property setting255



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint