Hello,
I am try to query a table with 7000 rows, and I only get a resultset with 1000.
I have SetMaxRows(0), so the resultSet can be of unlimited size, and yet I only get 1000 rows. My Query is "Select * from Patients", because I need to read the entire table.
Is there a limit set in the Access Library that is not allowing more than 1000 rows?
If there is no limit, how can I access all 7000 rows?
OR
How can I get the first 1000 and then the next 1000 and then 1000 more until all 7000 are read?
Thank you very much for your help.
Sincerely,
Elena daSilva
|
Yeah. It's an evaluation limitation at here.
|
Thank you for the answer!!
I forgot to download the full version after buying the license.
|