Can't Update Database (Resovled)
Hi when i try to update my db i get this error
http://htmlschool.co.uk/images/prollem.JPG
this is the code that it has a problem with
VB Code:
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