<div>
Edited text of question<br />

</div>


<div>
I teach RDO to my students ! I can open an updatable resultset<br />
and any DAO recordset turns out to be read-only. I thought this<br />
could be a well-known bug and somebody could tell me the latest<br />
bug-free version.<br />

</div>


I teach RDO to my students ! I can open an updatable resultset
and any DAO recordset turns out to be read-only. I thought this
could be a well-known bug and somebody could tell me the latest
bug-free version.


<div>
<div class="content wysiwyg-content">
Set mydb = Opendatabase(&quot;&quot;,false,fals<wbr />e,&quot;ODBC;DS<wbr />N=MSSQLSRV<wbr />;&quot;)<br />
Set Data1.Recordset = mydb.OpenRecordset(&quot;test_t<wbr />able&quot;,dbOp<wbr />enDynaset)<wbr /><br />
Now if I check Data1.Recordset.Updatable , it is false. Why ? mydb.Updatable is True. How can I create an updatable recordset on Data1 without setting the Data Control's Connect and Datasource property. I dont want the Data Control to open a connection of its own to the MS SQL Server 6.5 I have also tried Dim rs as Recordset but even rs turns out to be Updatable False.
</div>
</div>


Set mydb = Opendatabase("",false,false,"ODBC;DSN=MSSQLSRV;")
Set Data1.Recordset = mydb.OpenRecordset("test_table",dbOpenDynaset)
Now if I check Data1.Recordset.Updatable , it is false. Why ? mydb.Updatable is True. How can I create an updatable recordset on Data1 without setting the Data Control's Connect and Datasource property. I dont want the Data Control to open a connection of its own to the MS SQL Server 6.5 I have also tried Dim rs as Recordset but even rs turns out to be Updatable False.

Recordset is not Updatable

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.