# Flash to ASP form isn't working...help!

**URL:** <https://forum.kirupa.com/t/flash-to-asp-form-isnt-working-help/128361>\
**Category:** Uncategorized\
**Created:** [November 11, 2004, 5:53pm UTC](https://forum.kirupa.com/t/flash-to-asp-form-isnt-working-help/128361 "2004-11-11T17:53:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![glowworm](https://avatars.discourse-cdn.com/v4/letter/g/f17d59/32.png) [@glowworm](https://forum.kirupa.com/u/glowworm)\
**Post date:** [November 11, 2004, 5:53pm UTC](https://forum.kirupa.com/t/flash-to-asp-form-isnt-working-help/128361/1 "2004-11-11T17:53:06Z")

</div>

I’m clueless when it comes to ASP, but I having to create a contact form for a site I’m working on in Flash. I’ve done some tutorials but for some reason it simply isn’t working. (yes, I do have ASP technology on the server). Here is what I got:  
 ![](http://www.specvid.com/images/form_screen.jpg)  
here is what my form looks like. All of the input text fields are in a movie clip called myForm. The fields are labeled:  
fname (first name)  
lname (last name)  
and so forth and so on…  
here is what my properties look like for those fields:  
 ![](http://www.specvid.com/images/prop_screen.jpg)

This is what my ASP page code looks like:

\<%@language = “VBScript” %\>  
\<%

strFirst = Request.Form(“fname”)  
strLast = Request.Form(“lname”)  
strEmail = Request.Form(“email”)  
strMessage = Request.Form(“message”)

MyPath=Server.MapPath(“webcontacts.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)  
%\>

Ok,now why isn’t this working??? I’m begging for help on this one. Here is a link to the site that the form is currently on (but of course, not working)  
[Spectrum Productions](http://www.specvid.com)