<div>
Your query is not updatable, probably becouse of some JOIN in it. Post quesry here, or rethink why recordset can not be updated. Maybe records are not uniquely identified...
</div>


Your query is not updatable, probably becouse of some JOIN in it. Post quesry here, or rethink why recordset can not be updated. Maybe records are not uniquely identified...

<div>
ok thanks angell, u prompted me in the right direction, the problem was the editmode settings for the adodc have no bearing on the recordset as it is defined by an SQL query so i defined write access in the SQL and it works thanks!
</div>


ok thanks angell, u prompted me in the right direction, the problem was the editmode settings for the adodc have no bearing on the recordset as it is defined by an SQL query so i defined write access in the SQL and it works thanks!

<div>
<div class="content wysiwyg-content">
Hi <br />
I wish to edit an item of data from a recordset using code, so far I have the following<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dbOrders.Recordset.Fields(<wbr />&quot;Prepared&quot;<wbr />).Value = Username.Text<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dbOrders.Recordset.Update<br />
<br />
I get the error &quot;Operation must use an updateable query&quot;, even though dbOrders.EditMode is set to &quot;write&quot;.<br />
Please Help<br />
Thankyou r1gga
</div>
</div>


Hi 
I wish to edit an item of data from a recordset using code, so far I have the following

               dbOrders.Recordset.Fields("Prepared").Value = Username.Text
               dbOrders.Recordset.Update

I get the error "Operation must use an updateable query", even though dbOrders.EditMode is set to "write".
Please Help
Thankyou r1gga

Simple AODC Data Question

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.