How many is too many

  • Thread starter Thread starter Ronda
  • Start date Start date
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
Does anyone know the max records Access can hold before it
brings a network to its knees?
 
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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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