Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    34

    Unanswered: Exceeded table size?

    Has anyone every exceeded the amount of records that Access will allow in a table? I was wondering if it is even possible and if so, what is the magic number?
    "If you are good you will be assigned all the work. If you are really good you will get out of it."

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    That depends a lot on the version of Access you're using, how many columns are in your table, and the data type of each column. Go into your Help screen in access, and in the index tab type "specification" in the keyword box.
    That will bring up you access specifications, and tell you how much data you can store in your table. It'll require you to do some math, though.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Nov 2003
    Posts
    34
    Great...I didn't even know that was there. Thanks!
    "If you are good you will be assigned all the work. If you are really good you will get out of it."

  4. #4
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    I haven't exceeded the table size, but I did once run out of fields, having reached the limit (128) for Access 97. That was when I realized I had to redesign the database ...


Posting Permissions

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