<div>
I'm thinking about the tables or views that you are accessing on the SQL Server side. Do you have permissions to do more than just read?<br />
<br />
Also certain types of queries are always read only. Then there is Access Secuirty permissions and SQL Server Security perms
</div>


<div>
also, see if your query &quot;qry101DistNewOrderCards&quot; falls in the items listed from this link<br />
<a href="https://msdn.microsoft.com/en-us/library/aa198446(office.10).aspx" rel="ugc nofollow">When can I update data from a query?</a>
</div>


<div>
Ah yes, the query is Dynaset (inconsistent updates). &nbsp;Is there a way of making it updateable via VBA.
</div>


<div>
LJKMartin: First make sure permissions are set to allow it in SQL Server and in Access. &nbsp;Is this VBA inside of Access itself?
</div>


<div>
Open the query in datasheet view. &nbsp;Can you update rows? &nbsp;If you can't then you can't use the query in VBA as an editable recordsource.<br />
<br />
What is making the query not updateable?
</div>


<div>
Yes, I can open the query in datasheet view and edit, but only because it's Dynaset (inconsistent updates). <br />
<br />
The option in VBA is dbOpenDynaset, so I guess that's not allowing inconsistent updates. &nbsp;Is there an option that allows inconsistent updates?<br />
<br />
The query selects from another that has outer joins - which makes it not updateable.<br />
<br />
I'm not sure what permissions I need to check, but there are dozens of other queries that work fine, so I'll be surprised if it's that.
</div>


<div>
Thanks Pat,<br />
<br />
Who'd have thought that Help would actually have the answer!
</div>


<div>
<div class="content wysiwyg-content">
Can someone point out why this code crashes at the .Edit saying &nbsp;that the database or query is read-only? <br />
<br />
The code is set in an Access 2010 front-end linked to a SQL Server database.<br />
<br />
The Access file is not read only - lots of similar procedures run OK.<br />
<br />
The dataset the query produces is updateable - i can open it manually and change the DistributeOrderCard field.<br />
<br />
<br />
<br />
Sub TestCust()<br />
Dim db As Database<br />
Dim recust As Recordset<br />
<br />
Set db = CurrentDb()<br />
<br />
'open customers<br />
&nbsp; &nbsp; Set recCust = db.OpenRecordset(&quot;qry101Di<wbr />stNewOrder<wbr />Cards&quot;, dbOpenDynaset, dbSeeChanges)<br />
'test<br />
&nbsp; &nbsp; recCust.Edit<br />
&nbsp; &nbsp; recCust![DistributeOrderCa<wbr />rd] = False<br />
&nbsp; &nbsp; recCust.Update<br />
End Sub
</div>
</div>


Can someone point out why this code crashes at the .Edit saying  that the database or query is read-only? 

The code is set in an Access 2010 front-end linked to a SQL Server database.

The Access file is not read only - lots of similar procedures run OK.

The dataset the query produces is updateable - i can open it manually and change the DistributeOrderCard field.



Sub TestCust()
Dim db As Database
Dim recust As Recordset

Set db = CurrentDb()

'open customers
    Set recCust = db.OpenRecordset("qry101DistNewOrderCards", dbOpenDynaset, dbSeeChanges)
'test
    recCust.Edit
    recCust![DistributeOrderCard] = False
    recCust.Update
End Sub

VBA Query won't Edit

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.