Access not seeing all records in table?

[ChopinFan]

I have three tables, each populated from its own CSV file and its own DTS package. Two of the three tables, however, didn't appear to load with the same number of records as exist in their respective CSV source files. For example, one CSV file has 10753 rows, but when I opened the table in the front end, it only showed 10000 rows. When I checked the table through EM, it showed all 10753. I started scratching my head and writing queries. I get different results when I query through Access versus through EM. If I do a simply count(*) in Access, it tells me it only finds 10000 rows, but when I group by a certain field, including a count for each and add the values together myself, I come up with the correct number of 10753.

Any idea what's going on? I've been told it's not a good idea to do any development through the front end, but until now I've not had any serious problems. I'm also concerned the results of my queries against these tables may not be correct. Thoughts?

 

[belovedcej]

In the form properties in Access, on the data tab, there is an option called Max Records. It defaults to 10000. It's not that Access isn't reading them, it's that the form won't load more than 10000 records at a time.

You can change that default to lower or higher. I think it is designed to prevent major slow downs in large DBs.

 

[ChopinFan]

In form properties, yes, but I was looking directly in the table, not via any form. Is there something like that that applies at the table level? If so, how do I change it?
Thanks.

 

[belovedcej]

sorry - don't know about that. I have never dealt with that much data, so I've never had reason to notice if the table has some kind of limit.

 

[souldude]

When you open the table, look down at the record navigation buttons at the bottom, click the [>!..] button (the last one), enter the number of records you want to see, and you should be good from there on.

-Souldude.

 

[ChopinFan]

Perfect, thanks!