A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How many is too many



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2004, 07:53 PM
Ronda
external usenet poster
 
Posts: n/a
Default How many is too many

Does anyone know the max records Access can hold before it
brings a network to its knees?
Ads
  #2  
Old April 28th, 2004, 08:03 PM
Rick B
external usenet poster
 
Posts: n/a
Default How many is too many

In the help file, type "specifications" to see the limits for your version
off access. Obviously "bringing the network to it's knees" would depend on
what you are doing. I have a database with 15,000 records. Most
queries/forms/reports run very smoothly. Some (like union tables) can take
minutes to load.

Rick B
"Ronda" wrote in message
...
Does anyone know the max records Access can hold before it
brings a network to its knees?


  #3  
Old April 28th, 2004, 09:20 PM
Jesper F
external usenet poster
 
Posts: n/a
Default How many is too many

I have a questionaire database (normalized like Duane
Hookom) taught us :-)
It'll have about half a million records in the answer
table.
Does anyone know if there are any problems with this
amount of records? On the plus side the big tbale only has
3 fiels:
ID, QuestionID, AnswerID
Thanks for any input.
  #4  
Old April 28th, 2004, 09:29 PM
Kevin3NF
external usenet poster
 
Posts: n/a
Default How many is too many

No explicit limit....hard limits are on file size. I have a table with 148K
records that pretty much flies.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

"Ronda" wrote in message
...
Does anyone know the max records Access can hold before it
brings a network to its knees?



  #5  
Old April 29th, 2004, 05:02 AM
John Vinson
external usenet poster
 
Posts: n/a
Default How many is too many

On Wed, 28 Apr 2004 13:20:34 -0700, "Jesper F"
wrote:

I have a questionaire database (normalized like Duane
Hookom) taught us :-)
It'll have about half a million records in the answer
table.
Does anyone know if there are any problems with this
amount of records? On the plus side the big tbale only has
3 fiels:
ID, QuestionID, AnswerID
Thanks for any input.


With a unique index on ID, and nonunique indexes on the other two
fields; and with regular compaction, Access can handle this OK. The
biggest Access app of which I'm aware has a hundred times more records
than yours.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
  #6  
Old April 29th, 2004, 09:49 AM
Jesper F
external usenet poster
 
Posts: n/a
Default How many is too many

With a unique index on ID, and nonunique indexes on the
other two
fields; and with regular compaction, Access can handle

this OK. The
biggest Access app of which I'm aware has a hundred

times more records
than yours.


Thank you John. Great to know. I'll just keep at it
then :-)
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 OfficeFrustration.
The comments are property of their posters.