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 :-)