Can't Update Database (Resovled)

[señorbadger]

Hi when i try to update my db i get this error



this is the code that it has a problem with

Set myrs = New ADODB.Recordset
        'set the varible to get ready
Set MyConn = New ADODB.Connection
        'set the varible to get ready
    connstr = "Provider=MS Remote;" & _
           "Remote Server=http://192.168.0.2;" & _
           "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=C:\Inetpub\wwwroot\BCIMusrs.mdb"
           MyConn.ConnectionString = connstr
    MyConn.Open
 
'the line below is the problem the stuff above might help i think
 
Set myrs = MyConn.Execute("UPDATE users SET ScreenName = '" 
& userscrname & "' WHERE Username ='" & employeeperson & "'")

Please Help

Sam Lad