ADP File - Hidden SQL Records

[TTops]

Hello,

I have a Microsoft Access 2003 ADP file that is connected to a SQL 2000 database. There are only two user tables in this database. When I open one of the tables in Access, approximately one month of data is not visible. When I open the same table in SQL Query Analyzer, the missing records are there. As a test I created a new ADP file on another computer and connected it to the same SQL database. The same records were not visible. It's almost as if the table is being filtered by default. Does anyone have any suggestions?

Thanks,
T-Tops

 

[JoeAtWork]

How do you define "not visible"? Is your table small enough that you can tell by just looking at it that records are missing? Have you compared record counts?

Note that if you have thousands of records they may not be all loaded at once. As you scroll down you may experience periodic pauses as it loads the next batch of records.

Note also that unless you are using an ORDER BY clause, you have no way of predicting the order the records will be loaded. I mention this in case you are expecting to see certain values in a particular row and you have concluded the row is missing when you don't see it where you think it should be - it may in fact just be somewhere further on.

If you are absolutely certain the rowcounts are actually different in Access, then perhaps the missing records do not have their primary field(s) value populated.

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[TTops]

JoeAtWork,

Thanks for the response. It turned out that we had recently reached the 10,000 records limit. When I found out how to set the datasheet property for "Set the Maximum Record Count" to zero, all the records became visible. What I still don't understand is how it filtered records from the middle of the table. In other words, once we reached 10,100 records, the one hundred that weren't visible were not the first one hundred or the last one hundred.



Thanks,
T-Tops

 

[PHV]

Because, unless you explicitly use an ORDER BY clause, there is no first nor last records ...