hej!
Varför funkar inte det här, jag hittar inte felet !?
Set Minconn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("databas/tabell1.mdb")
Minconn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
b1 = replace(request.form("b_1"),"'","''")
b2 = replace(request.form("b_2"),"'","''")
b3 = replace(request.form("b_3"),"'","''")
b4 = replace(request.form("b_4"),"'","''")
b5 = replace(request.form("b_5"),"'","''")
b6 = replace(request.form("b_6"),"'","''")
b7 = replace(request.form("b_8"),"'","''")
b8 = replace(request.form("b_8"),"'","''")
b9 = replace(request.form("b_9"),"'","''")
b10 = replace(request.form("b_10"),"'","''")
b_namn = request.form("b_namn")
plder = request.form("plder")
' rad 474 nedan
Minconn.Execute ("Update Tabell1 SET Namn = '" & b1 & "', Frnt = '" & b2 & "', Bck = '" & b3 & "', Insd = '" & b4 & "', ccd1 = '" & b5 & "', ccd2 = '" & b6 & "', ccd3 = '" & b7 & "', ccd4 = '" & b8 & "', plder = '" & b9 & "', tck = '" & b10 & "' Where plder = " & plder & b_namn = " & b_namn & ")
Minconn.Close
%>
felmeddelande
Microsoft OLE DB Provider for ODBC Drivers fel '80040e14'
[Microsoft][Drivrutin för ODBC Microsoft Access] Ogiltigt SQL-uttryck. 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' eller 'UPDATE' förväntades.
/admin.asp, rad 474
------------------
...