cannot write to Database

Hi,
I am using Win XP and running an IIS.I am sending data thru flash +ASP and accessing Access database.
I am able to read and display data from the Database but cannot write, I get the following error.

<LI>Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/flaASP/processForm.asp, line 15


<LI>Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)

<LI>Page:
POST 39 bytes to /flaASP/processForm.asp

<LI>POST Data:
fname=fs&lname=asf&email=sf&message=asf

I have logged in as administrator and my partition is NTFS.I somehow donot get the security tab feature in the
property sheet for my site folder, wherein i could check for the permissions to access the database.I am not sure whats the problem.

Any help would be highly appreciated.

VB script code:
<%@language = "VBScript" %>
<%
strFirst = Request.Form("fname")
strLast = Request.Form("lname")
strEmail = Request.Form("email")
strMessage = Request.Form("message")
MyPath=Server.MapPath("example.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&"')"
Set recordSet = Server.CreateObject("ADODB.Recordset")
recordset.open SQL,conn
set conn=nothing
set recordset=nothing
%>

thanks in advance,
cheers
Nashel

Do a search for "updateable query", this question has been asked many times.

Got it working!!!..
Well, i didnt give the full access control within the security tab, which i got only after activated from the folder options where i had my files stored in the PWS.Thanks anyways.

cheers,
Nashel

Alright Nashel. im doin a simular thing to what you are using Dreamweaver MX and an access database on win XP. I bin havin the same trouble so could you put up some more details about how you solved it cos i can't work it out!
cheers
PJ

I have some information on this error here, maybe it will help you out

http://www.dougscode.com/forum4/topic.asp?TOPIC_ID=5