problem editing adodb recordset
I've created a recordset in VB Express 2008 as follows
rsmembers = New ADODB.Recordset
.Source = cn.Execute("SELECT * FROM members")
.ActiveConnection = cn
.CursorType = ADODB.CursorTypeEnum.adOpenDynamic
.LockType = ADODB.LockTypeEnum.adLockOptimistic
.CursorLocation = ADODB.CursorLocationEnum.adUseServer
.Fields("Active").Value = vbFalse
but the error window tells me that .fields("active") active is readonly. Tried using cursortype as adopenkeyset and tried without the Source property being set as well but same error.
Can anybody tell me how to this please.