I am just trying out the batchupdate method on a recordset and I am getting an error: "Insufficent base table information for updating or refreshing", when I issue the .updatebach method.

This is my code:

strSql = "SELECT TABLE.* From TABLE WHERE TABLE_REPORT)=True));"
With rstBatchUpdate
.ActiveConnection = mstrConnection
.LockType = adLockBatchOptimistic
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.Open strSql, Options:=adCmdText
.MoveFirst
Do Until .EOF
.Fields("EFSPROD_REPORT") = false
.MoveNext
Loop
.UpdateBatch
.Close
End With

What am I missing here, any clues?