Runtime Error 3027 DAO Recordset Any Help...

[Brandon Johnson]

Hello im having a bit of problems with editing a field in a table using
DAO. The error is tossed at the point where i initialize the Edit
feature: If anyone has any thoughts please let me know. it doesnt make
any sense to me cuz i dont see why the db or object would be read only.
Havent done anything to make it readonly. Thanks for the help

Set Maindao = CurrentDb.OpenRecordset("SELECT DISTINCT PromoteGroup,
Client, UPCCase, UPCItem FROM tblItemPromoteGroups;", dbOpenDynaset)
mainCriteria = "[PromoteGroup] = '" & promotes & "'"

Maindao.FindFirst mainCriteria
Maindao.Edit
Maindao!Client = txtClient
Maindao!PromoteGroup = txtPromote
Maindao!UPCCase = txtCaseUPC
Maindao!UPCItem = txtItemUPC
Maindao.Update
Maindao.Close

 

[Allen Browne]

Is this query updateable?

Try pasting the query statement into SQL View of a query, and see if it is
read-only. If so, the attempt to Edit is not going to succeed.

For more info, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html