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. 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. 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. 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
     

Share This Page