UPDATE i databasen.

[query]
set conn = server.createobject("ADODB.connection")
conn.Open application("dbconx")

Set rsVare = Server.CreateObject("ADODB.Recordset")
      rsVare.open "SELECT * FROM vare", conn
        do while not rsVare.eof
      strsql = "UPDATE Vare_Pris SET Vare_navn='" & rsVare("Navn") & "' WHERE Vare_id='" & rsVare("VareID") & "'"
    conn.Execute strsql   
    rsVare.movenext
    loop
[/query]

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/newphillip.asp, line 11

for den felj forstå ikke hvorfor :S