recordset problem

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.

thank you

ny971181
LVL 1
ny971181Asked:
Who is Participating?
 
sachinkasConnect With a Mentor Commented:
Try giving movelast to the recordset and check. Also could you paste the code that you are trying to work out.
0
 
ny971181Author Commented:
Edited text of question
0
 
dipal_shahCommented:
I think you are using VB Enterprise addition. I was facing the same problem. I used RDO control and it got solved. I suppose there is some problem with MS - Jet shipped with Enterprise edition.


dipal
0
 
dipal_shahCommented:
I think you are using VB Enterprise addition. I was facing the same problem. I used RDO control and it got solved. I suppose there is some problem with MS - Jet shipped with Enterprise edition. IF you will run the same query under Visual Data manager it will return only one row. So don't waste time for that and use RDO control.

Dipal
0
 
ny971181Author Commented:
Thank you but I can't use RDO control.

ny971181
0
All Courses

From novice to tech pro — start learning today.