Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

General Question About Records In A Table

Discussion in 'Information Technology' started by tanhus, Jul 28, 2006.

  1. tanhus

    tanhus
    Expand Collapse
    Guest

    I was just wondering, if access has a maximum number of records it can hold
    in a given table.
     
  2. Loading...

    Similar Threads Forum Date
    Just A Few General Questions? Sikh Sikhi Sikhism Apr 7, 2013
    General Why Is The World In Such A Horrid State? Some General Questions Hard Talk Jun 28, 2011
    General Questions About Jaap Sahib Sikh Sikhi Sikhism Feb 21, 2008
    World War 1 British Army General Speaks About Sikhs History of Sikhism Dec 8, 2015
    UK Amandeep Singh Bhogal - First Indian-origin Sikh Politician To Contest Uk General Elections Breaking News Apr 10, 2015

  3. OP
    Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    No, it doesn't.

    The only limit is the fact that a single MDB file cannot exceed 2 Gb.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    news:275C5E62-87FF-40AD-9624-D4CC9291ECE9@microsoft.com...
    > I was just wondering, if access has a maximum number of records it can

    hold
    > in a given table.
     
  4. OP
    Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    news:275C5E62-87FF-40AD-9624-D4CC9291ECE9@microsoft.com...
    >I was just wondering, if access has a maximum number of records it can hold
    > in a given table.


    The maximum is only on the file size. 1GB for Access 97 and older. 2GB for all
    newer versions. Assuming Jet (MDB) tables of course.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  5. OP
    Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    tanhus <tanhus@discussions.microsoft.com> wrote:

    >I was just wondering, if access has a maximum number of records it can hold
    >in a given table.


    FWIW a friend a while back had 100,000,000 records in a table. Daily
    closing stock prices for a few years. Fully normalized.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page