Access quiery

[Rod]

I have created a table with just over 1million rows which
I wish to query. However the query is not showing all the
relevant records, they exist in the table but not in the
query, they seem to be missing in a random way. I am
guessing that it is a memory problem, has anyone any
experience of something similar.

My lap top has 512Mb of DDR SDRAM on board.

 

[John Vinson]

I have created a table with just over 1million rows which
I wish to query. However the query is not showing all the
relevant records, they exist in the table but not in the
query, they seem to be missing in a random way. I am
guessing that it is a memory problem, has anyone any
experience of something similar.

A Query, particularly a big one, will start showing results
immediately; the search will continue in the background. How are you
viewing the results? If you wait a couple of minutes does it show the
additional records? or if you page down/scroll down the datasheet
window, do the additional records appear?