How many is too many

[Ronda]

Does anyone know the max records Access can hold before it
brings a network to its knees?

 

[Rick B]

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?

 

[Jesper F]

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.

 

[Kevin3NF]

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.

 

[John Vinson]

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.

 

[Jesper F]

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