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

Hi

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

Kev

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.