<div>
Use method 2 it gives you more control when you use DAO.<br />
<br />

</div>


Use method 2 it gives you more control when you use DAO.



<div>
hi edward98,<br />
just to know why, can u please give more details, of why this is so.<br />
<br />
alok.<br />

</div>


hi edward98,
just to know why, can u please give more details, of why this is so.

alok.


<div>
Yes, i would like to know the reason behind as well.<br />
Thanks<br />
<br />
chee<br />
<br />

</div>


Yes, i would like to know the reason behind as well.
Thanks

chee



<div>
you can buy commercial performance tools. &nbsp;NuMega and Rational both make them, though rational's only works on NT.<br />

</div>


you can buy commercial performance tools.  NuMega and Rational both make them, though rational's only works on NT.


<div>
<div class="content wysiwyg-content">
If i want to open a recordset, &nbsp;which way works better in terms of performance, maintenance, accuracy and ease of programming<br />
<br />
method 1<br />
1. use data control<br />
<br />
method 2<br />
1. &nbsp;open the recordset manually;for example<br />
Dim MyRS as recordset<br />
set MyRS = mydb.openrecordset(&quot;Table1<wbr />&quot;)<br />
<br />
the recordset record will be updated by user operation.<br />
<br />
Thanks<br />
<br />
chee
</div>
</div>


If i want to open a recordset,  which way works better in terms of performance, maintenance, accuracy and ease of programming

method 1
1. use data control

method 2
1.  open the recordset manually;for example
Dim MyRS as recordset
set MyRS = mydb.openrecordset("Table1")

the recordset record will be updated by user operation.

Thanks

chee

Open a Recordset

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.