<div>
Edited text of question<br />

</div>


<div>
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.<br />
<br />
<br />
dipal<br />

</div>


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


<div>
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.<br />
<br />
Dipal<br />

</div>


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


<div>
Thank you but I can't use RDO control.<br />
<br />
ny971181<br />

</div>


Thank you but I can't use RDO control.

ny971181


<div>
<div class="content wysiwyg-content">
hi, I am connecting a VB to a Access db. <br />
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. <br />
By the way, I open another recordset within the same module, It returns the records that I expected.<br />
<br />
How come it only returns one record to me? <br />
What is the possible cause to this problem?<br />
I don't think syntax is the problem, 'cause I checked it no less than 20 times.<br />
<br />
thank you<br />
<br />
ny971181<br />

</div>
</div>


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


recordset problem

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.