Hello,
I am not exactly sure if it is the best place for my question, if not sorry!
So, I have an MS SQL 2000 backend with Access 2003 frontend. Some forms' recordset is set in runtime by run a stored procedure on the backend and its result is the recordset. It works good and fast enough, my only problem is that if I check the record count of the given form, first time I always get maximum 59 instead of the real number. If it is less than 59 no problem, only if the resultset's record count is more than 59.
Does anybody have similar experience or any idea what could cause this?
Many thanks in advance for every little tips!
Regards,
VoiD
I am not exactly sure if it is the best place for my question, if not sorry!
So, I have an MS SQL 2000 backend with Access 2003 frontend. Some forms' recordset is set in runtime by run a stored procedure on the backend and its result is the recordset. It works good and fast enough, my only problem is that if I check the record count of the given form, first time I always get maximum 59 instead of the real number. If it is less than 59 no problem, only if the resultset's record count is more than 59.
Does anybody have similar experience or any idea what could cause this?
Many thanks in advance for every little tips!
Regards,
VoiD
