Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page