3027 cannot update database or object is read only

Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here. I am trying to update current record being processed in a loop based on a SQL statement. But I am getting the error " Cannot update. Database or object is read-only. Edit rsGenerateMe! SurveyNumber rsGenerateMe. Update rsGenerateMe. EOF If rsd! Edit rsd! Update End If If rsd! Update End If End If rsd. MoveNext Loop salir: rsd. HansUp Add a comment. Active Oldest Votes. Updatable then But you might have a bigger problem.

Your declaration doesn't match your usage. Dim rsd As DAO. If rsd! Edit See the difference? Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Now i m doubt where i go wrongs OpenRecordset sql3, dbOpenDynaset for these lines of coding are for testing use.

Did you read what I said? Run time Error: Can't update database or object is readonly. Error Error Cannot update, Database or Object is read only. Read only unable to update error code DAO error Can't update. Database or object is read-only Error OpenRecordset sql3, dbOpenDynaset.