Access quiery

  • Thread starter Thread starter Rod
  • Start date Start date
R

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

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?
 
Back
Top