J
jason
I am picking up an error message on a straightforward INSERT - do I need an
optimistic-type to get this working....here is is the error:
Microsoft JET Database Engine error '80004005' Operation must use an
updateable query. /catamaranco/accounts/email_inc.asp, line 264
Set cnn = CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("../database/acc.mdb") '//This one is for Access 2000/2002
cnn.Open(strCon)
SQL = "INSERT INTO tblCheck_Request (Department_ID, Authorizer_ID,
Requester_ID, Payee, Check_Reason, Amount, Deadline_Date, Yacht) VALUES ("
SQL=SQL & "'" & Department_ID & "', "
SQL=SQL & "'" & Authorizer_ID & "', "
SQL=SQL & "'" & Requester_ID & "', "
SQL=SQL & "'" & Payee & "', "
SQL=SQL & "'" & Check_Reason & "', "
SQL=SQL & "'" & Amount & "', "
SQL=SQL & "'" & Deadline_Date & "', "
SQL=SQL & "'" & Yacht & "')"
Response.Write SQL
Set rs = cnn.Execute(SQL)
optimistic-type to get this working....here is is the error:
Microsoft JET Database Engine error '80004005' Operation must use an
updateable query. /catamaranco/accounts/email_inc.asp, line 264
Set cnn = CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("../database/acc.mdb") '//This one is for Access 2000/2002
cnn.Open(strCon)
SQL = "INSERT INTO tblCheck_Request (Department_ID, Authorizer_ID,
Requester_ID, Payee, Check_Reason, Amount, Deadline_Date, Yacht) VALUES ("
SQL=SQL & "'" & Department_ID & "', "
SQL=SQL & "'" & Authorizer_ID & "', "
SQL=SQL & "'" & Requester_ID & "', "
SQL=SQL & "'" & Payee & "', "
SQL=SQL & "'" & Check_Reason & "', "
SQL=SQL & "'" & Amount & "', "
SQL=SQL & "'" & Deadline_Date & "', "
SQL=SQL & "'" & Yacht & "')"
Response.Write SQL
Set rs = cnn.Execute(SQL)