hi, I am connecting a VB to a Access db.
I try to open the recordset from a table. But it returns only one row of records for me. So I went back to Access and test it in the query. I got 4 records.
By the way, I open another recordset within the same module, It returns the records that I expected.
How come it only returns one record to me?
What is the possible cause to this problem?
I don't think syntax is the problem, 'cause I checked it no less than 20 times.