Darren DICK
d.dick at uws.edu.au
Tue Feb 3 19:09:37 CST 2004
Hello all Can anyone tell me why I get the following Error message when I try and update the following record set? ================================================= Error Number 3251 Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype ================================================= Code... Dim con As Object Dim rs As Object Dim sel_SQL As String Set con = Application.CurrentProject.Connection Set rs = CreateObject("ADODB.Recordset") sel_SQL = "SELECT tblMyTable.*, tblMyTable.FieldToBeUpdated FROM tblMyTable" _ & "WHERE (((tblMyTable.FieldToBeUpdated ) Is Not Null)); rs.Open sel_SQL, con, 1 '<====Error line is here somewhere me thinks With rs While Not .EOF !FieldToBeUpdated = -1 .MoveNext Wend End With