Insufficient Base Table Information

[Sam63]

I'm getting the run time error:

Insuffcient base table information for updating or refreshing.

I am designing a login screen and I want to update a boolean field that indicates that someone is logged into the database. I have the login working but cannot get the record to update because of this error.

snippet of my code is below:
....
strQ = "select *from tblUsers where fldEmployeeID = " & "'" & txtUserID.Text & "'"
adoUsers.RecordSource = strQ
adoUsers.Refresh
....
adoUsers.Recordset.Fields("fldLoggedIn&quot = True
adoUsers.Recordset.Update ****errors at this line******
adoUsers.Recordset.MoveNext


thanks for your help.

Sam

 

[WilMead]

You'd be much better off using an update query.

Wil Mead
wmead@optonline.net

 

[Sam63]

what is an update query???

Sam

 

[dwong]

Sam63,

Do you have the problem still? I have exactly the same message, although this time I am updating the table via a DataGrid connected to an ADO.

As to Wilmead's reply above, which event would I put the Update query?

Thanks and regards...