Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Question Unanswered: Is There a Table Record Limit?

    I know (or at least I think I do) that the max mdb size is around 2gb. My little database will never get that big.

    But, is there a limit on the number of records that a table can hold?

    I have one table that has just over 10,000 records after 5 months.

    These records are pretty small though, the largest field being a memo. Few with over 300 characters.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    No limit unless............

    Table specifications

    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.............................1,024.
    The actual number may be less because of tables open internally by Microsoft Access.

    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 the user interface)
    (when entering data programmatically.........1 gigabyte)
    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 (excluding Memo and OLE Object fields)....2,000

    Number of characters in a field property setting....255



  3. #3
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179

    Thumbs up

    GREAT INFO CyberLynx

    Where did you find the specifications???

    I've been looking everywhere for them!!!!

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    The MSAccess Help File

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •