A program to recognize and reward our most engaged community members
I have an Access Database with 75k rows. I have a query that should display 32k rows. In DPS, it only displays 6402 rows (all queries are displaying approx this number).
Is this a known issue? Is there a solution?
Is it safe to assume you have already checked for the default Data Source Row Limit setting?
Grant
Is it safe to assume you have already checked for the default Data Source Row Limit setting? Grant
Yep, no row limit is set.
Ok.
Well I went and found an old test database I have not used for a while and never in DPS.
This one is showing just over 5 Million records in the mdb file and the query I chose extracts just over 550,000 records. The number of records repoeted as selected by the SQL query and DPS agrees.
That suggests there is not a complete fundamental problem.
Sadly it does not explain your result.
FWIW I'm running V14.3 .
