batchupdate

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?

I can dig why there are no responses to this topic - it works. Well, that is to say, it works on the server at work, not on my zip drive at home. Usually its the other way around.

curious.