Why won't UPDATE work? [resolved]

[bjawnie]

Hii,

Why won't this code work? I have been using it to update a datetime field without any probs., but know I get this error when I try to update the IP field:

Run-Time Error '-2147217887' (80040e21):

Set rs = New ADODB.Recordset
rs.Open "Select IP FROM m_members where id = " & struser_id & " ", conn, 3, 3
        rs!IP = Winsock1.LocalIP
rs.Update
rs.Close
Set rs = Nothing

[bjawnie]

I couldn't figure out what the problems was, so I replaced the whole code...

[Destined Soul]

My two questions for this problem:

1) Is the user id a number or string?
2) Did the record you were searching for exist?

Okay, 3 questions:

3) Did the error occur only on the "rs!IP = ..." statement?

Destined

[bjawnie]

Hii,

as I wrote my prob. has been resolved and I don't know what caused the error cause I ended up replacing the whole code.

I think that it might have been the OPTION function in my Connectionstring which I didn't include in the topic