vad är detta för fel ?


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/logg/add_post.asp, line 70

dim sql_insert
connect.Open(dbname)
sql_insert = "INSERT INTO noc (emswono, siteid, town, prio, dispatchtonmcdate, dispatchtonmctime, evaluationnoc, evaluationslm, accecptedbynmcdate, accecptedbynmctime, refmovex, dispatchtofsdate, dispatchtofstime, evaluationnmc, responsfromfsdate, responsfromfstime, movexteam, flmengineername, flmengineerphone, sitearrivaldate, sitearrivaltime, faultrepaireddate, faultrepairedtime, evaluationaddtime, evaluationflm, evaluationhw, evaluationsw, evaluationothers, sign) VALUES ('" & emswono & "', '" & siteid & "', '" & town & "', '" & prio & "', '" & dispatchtonmcdate & "', '" & dispatchtonmctime & "', '" & evaluationnoc & "', '" & evaluationslm & "', '" & accecptedbynmcdate & "', '" & accecptedbynmctime & "', '" & refmovex & "', '" & dispatchtofsdate & "', '" & dispatchtofstime & "', '" & evaluationnmc & "', '" & responsfromfsdate & "', '" & responsfromfstime & "', '" & movexteam & "', '" & flmengineername & "', '" & flmengineerphone & "', '" & sitearrivaldate & "', '" & sitearrivaltime & "', '" & faultrepaireddate & "', '" & faultrepairedtime & "', '" & evaluationaddtime & "', '" & evaluationflm & "', '" & evaluationhw & "', '" & evaluationsw & "', '" & evaluationothers & "', '" & sign & "') "

connect.Execute(sql_insert)
mvh
/johan

skrivrättigheter möjligtvis

jag hade bara valt scripts.. inte executeable.... tackar....

Skrivar rättigheter på databasfilen för IUSER_Datornamn.