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