I am using this syntax to address the database :
Dim rs As RecordSet
rs = SQLDatabase.SQLSelect (“EXEC spName @P1, @P2…”)
rs may contain records, but rs.recordcount is ALWAYS -1
I tried to put rs in the method and count them using WHILE not Eof, and because I need to loop the recordset, at the end of the method, I used rs.movefirst. I got the recordcount, but then “MoveFirst” acted as MovePrevious, so my recordSet was positioned at the last record instead the first.
Any suggestion where I am mistaking?