0

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)
%>
2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by kevinwebster83
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.