# Flash Forms and ASP-Please Help!

**URL:** <https://forum.kirupa.com/t/flash-forms-and-asp-please-help/118935>\
**Category:** Uncategorized\
**Created:** [August 10, 2004, 10:45am UTC](https://forum.kirupa.com/t/flash-forms-and-asp-please-help/118935 "2004-08-10T10:45:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdass](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@mdass](https://forum.kirupa.com/u/mdass)\
**Post date:** [August 10, 2004, 10:45am UTC](https://forum.kirupa.com/t/flash-forms-and-asp-please-help/118935/1 "2004-08-10T10:45:27Z")

</div>

Hi everyone,

I used one of your tutorials [http://www.kirupa.com/developer/actionscript/forms\_database.htm](http://www.kirupa.com/developer/actionscript/forms_database.htm) to learn the integration between Flash forms and Access Database. However, my program doesn’t work. It gives “Unupdatable Query” error. I’ve also tried looking at other related forums here. But I still can’t figure out how to solve the problem.

I’m using IIS,Access 2000 and i’m storing all my files in [color=#003366]C:\Inetpub\wwwroot estForm[/color]

[color=black]I’ve tried using getURL and loadVariableNum. My IIS works fine. Could anyone please help to highlight what am I doing wrong? Here are codes.[/color]

**Code in Flash MX (instance name fname, lname, mailadd, message, submitBttn)**

```auto

on(press)
{
loadVariableNum("processForm.asp",0,"POST");
}

```

**Code in processForm.asp (created using DreamweaverMX)**

```auto

<<A href="mailto:%@LANGUAGE="VBSCRIPT">%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[http://www.w3.org/TR/html4/loose.dtd](http://www.w3.org/TR/html4/loose.dtd)">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
Dim conn,sql_insert
strFirst = Request.Form("fname")
strLast = Request.Form("lname") 
strEmail = Request.Form("mailadd")
strMessage = Request.Form("message")
 
Response.Write(strFirst)&"<br>"
Response.Write(strLast)&"<br>"
Response.Write(strMail)&"<br>"
Response.Write(strMessage)
 
myPath=Server.MapPath("contactdb.mdb")
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver(*.mdb)};"&"DBQ="&myPath
sql_insert="INSERT INTO contact(FirstName,LastName,Email,Message)VALUES('"&strFirst&"','"&strLast&"','"&strMail&"','"&strMessage&"')"
conn.Execute sql_insert
%> 
</head>
<body>
 
</body>
</html>
 

```

---

<div class="post-metadata">

**Author:** ![mdass](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@mdass](https://forum.kirupa.com/u/mdass)\
**Post date:** [August 12, 2004, 1:45am UTC](https://forum.kirupa.com/t/flash-forms-and-asp-please-help/118935/2 "2004-08-12T01:45:06Z")

</div>

Hi everyone,

I can’t seem to load the user inputs from the Flash Form into variables in ASP.  
Could anyone help me? I sincerely appreciate your help.

Thank you.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 12, 2004, 2:55am UTC](https://forum.kirupa.com/t/flash-forms-and-asp-please-help/118935/3 "2004-08-12T02:55:06Z")

</div>

A common problem for the “Updatable Query” is that the IUSR account on the web server must have write permissions.