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")

	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&"')"


Try looking into the permissions you have set in IIS for the folder that the processForm.asp file lives in. It could be something to do with only having read permissions. Or maybe even the permissions on the Access database too