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