Re: Table Row Limit Size?

Thanks to all who answered.

Your words were helpful in enhancing the client's view of the situation!!

Alan


"Jerry Whittle" <JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:995EA679-7559-487F-8C01-D94DE8B19DD2@xxxxxxxxxxxxxxxx
A few weeks ago we had a contest to see who could squeeze the most rows
into
an Access table. The winner had over 133 million rows! Of course that
table
had just one column containing just one character per record. In the real
world I've seen Access tables with over 2 million records and perform OK.
160K records shouldn't be a problem if the tables are normalized properly.

Rule #1. Clients, bosses, and users lie.
Rule #2. When they swear that they aren't lying, see Rule #1.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Alan Z. Scharf" wrote:

Is there a maximum number of rows advised in an Access 2003 table?

Client says table with 160,000 rows is not allowed, and an MS support
engineer agreed with him.

I've never heard of this, and in fact the database has been operating
with a
table that large for several years.

If there is no such actual or recommended limit, can someone please
direct
me to an official source that says that?

Thanks very much.

Alan


.

Relevant Pages

  • Re: True odds bets?
    ... That is not ridicules. ... Steen is just confused about some of those changing parameters. ... You morphed into the WINNER that you undeniably are while Steen and Alan ...
    (rec.gambling.craps)
  • Re: My Website
    ... Because those of us who write commercial web sites for clients who pay us to do so have a responsibility to those clients *not* to exclude a hefty proportion of their potential site visitors. ... You operate in an academic environment, Alan, and that's just fine - it gives you the freedom to write your pages in a manner which can encourage visitors to educate themselves in the use of their browsers. ... If I write a web site which is aimed at potential purchasers of chain-link fencing, educating them in how to get the best out of the web is very, very low on my list of priorities. ...
    (uk.net.web.authoring)
  • Re: CRY BABY "Alan Erskine" (alanerskine1@bigpond.com)
    ... Allans being nominated for the next head of NASA, ... election.That is assuming we have a winner. ... bush with no clear winner might support Alan for president:) ...
    (sci.space.shuttle)
  • Re: The US Open gets the champion it deserves
    ... The point I made, Alan, is that the winner was better able to cope with the conditions. ... From what I saw and read, allplayers were rained on, just some more than others. ...
    (uk.sport.golf)
  • Re: How to automatically populate hosts.deny file
    ... That looks like a winner to me! ... alan wrote: ... I'm running RHEL 4 and I'm trying to get some input on how people automate populating the /etc/hosts.deny file? ...
    (RedHat)