Access 2007 ADP - recordsource not displaying all records

[Bill Kuhn - MCSE]

I've inherited an Access 2003 MDB -> Access 2007 ADP conversion project. I'm
a SQL, VFP, and .NET developer, not an Access developer.

The main form on this project opens a table (not a filter/query/view - just
a simple SQL table) which has 9751 records on the SQL server. The form
toolbar at the bottom shows records 1 through some random number of records
from 3200 - 9751 when you open the form. The toolbar is set with max records
= 0 (it originally had max records = 10000 which should have worked anyway).
It is not pulling all the records.

If you click on the toolbar and change the max number of records option, it
will then apparently requery the table and lo and behold you will see the
full 9751 records on the toolbar. Save the project and open it again and
you'll again get some random number of records (not 9751) on the toolbar.
This process is absolutely useless for the client.

What gives (I realize it is Access but SOMETHING should work properly in the
product..?)??

If I select * from the table in SQL Management Studio I get the entire table
(9751 records) in a flash. If I connect from VFP and select * from the table
into a cursor it takes less than a second (and I get 9751 records).

 

[Robert Morley]

I have no experience with Access 2007, but since it's an Access 2003 project
originally, have you tried replicating this in Access 2003 (if you have a
copy available)? If it works fine in 2003, then I'd be VERY inclined to
think it's a bug in 2007.


Rob