i am doing the database connectivity using the flash and access database...
The problem is i m not able to do any insert or update query on my database..
the only thing i can do is an select query..
The error is as follows..
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/example/processForm.asp, line 15
what should i do??? i m stuck up since many days...
asp code is as below
<%@language = "VBScript" %>
<%
strFirst = Request.Form("fname")
strLast = Request.Form("lname")
strEmail = Request.Form("email")
strMessage = Request.Form("message")
MyPath=Server.MapPath("ex.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath
SQL = "INSERT INTO contacts (FirstName, LastName, Email, Message) VALUES ('"&strFirst&"','"&strLast&"','"&strEmail&"','"&strMessage&"')"
conn.Execute(SQL)
%>