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?
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.
Yeah. It's an evaluation limitation at here.
Thank you for the answer!!
I forgot to download the full version after buying the license.