If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Table Row Limit Size?
On Thu, 1 Feb 2007 16:32:06 -0800, fredg
wrote: Let's not make a big row out of this. it was just a little lie. g Just hope that some pun-tificator doesn't wash your mouth out with lie soap! John W. Vinson[MVP] |
#12
|
|||
|
|||
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" wrote in message ... 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 |
#13
|
|||
|
|||
Table Row Limit Size?
That response may not be suitable for a public newsgroup, as it is
particularly caustic... Regards Jeff Boyce Microsoft Office/Access MVP "John Vinson" wrote in message ... On Thu, 1 Feb 2007 16:32:06 -0800, fredg wrote: Let's not make a big row out of this. it was just a little lie. g Just hope that some pun-tificator doesn't wash your mouth out with lie soap! John W. Vinson[MVP] |
#14
|
|||
|
|||
Table Row Limit Size?
On Fri, 2 Feb 2007 08:34:43 -0800, "Jeff Boyce"
wrote: That response may not be suitable for a public newsgroup, as it is particularly caustic... We'll need to get one of the acid-tongued trolls to reply to neutralize it. John W. Vinson[MVP] |
#15
|
|||
|
|||
Table Row Limit Size?
pHpHpH-ttt
Jeff "John Vinson" wrote in message ... On Fri, 2 Feb 2007 08:34:43 -0800, "Jeff Boyce" wrote: That response may not be suitable for a public newsgroup, as it is particularly caustic... We'll need to get one of the acid-tongued trolls to reply to neutralize it. John W. Vinson[MVP] |
|
Thread Tools | |
Display Modes | |
|
|