# Problems with Kirupa's FLASH to MDB ASP database

**URL:** <https://forum.kirupa.com/t/problems-with-kirupas-flash-to-mdb-asp-database/176782>\
**Category:** flash\
**Created:** [January 26, 2006, 8:50pm UTC](https://forum.kirupa.com/t/problems-with-kirupas-flash-to-mdb-asp-database/176782 "2006-01-26T20:50:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![MagicMan](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@MagicMan](https://forum.kirupa.com/u/MagicMan)\
**Post date:** [January 26, 2006, 8:50pm UTC](https://forum.kirupa.com/t/problems-with-kirupas-flash-to-mdb-asp-database/176782/1 "2006-01-26T20:50:29Z")

</div>

After following the example in this site and building the form, ASP and FLASH exactly like Kirupa did… I find that the code is creating a ROW in the database but there’s NO data to be found!

As a matter of fact, the code for getting the form data; isn’t!

Here’s my ASP page code:

\<%@language = “VBScript” %\>  
\<%  
strFirst = Request.Form(“fname”) \<-The names of my INPUT fields  
strMI = Request.Form(“mi”) \<-The names of my INPUT fields  
strLast = Request.Form(“lname”) \<-The names of my INPUT fields

Response.Write(strFirst) & “\<br\>” \<-- This to…  
Response.Write(strMI) & “\<br\>”  
Response.Write(strLast) \<-- …here doesn’t show a thing!

MyPath=Server.MapPath("/database/TrainingDatabase.mdb")  
Set conn = Server.CreateObject(“ADODB.Connection”) ’  
conn.Open “Driver={Microsoft Access Driver (\*.mdb)};” & \_  
“DBQ=” & MyPath  
SQL = “INSERT INTO tbl\_ALL\_DATA (first\_name, mi, last\_name) VALUES (’”&strFirst&"’,’"&strMI&"’,’"&strLast&"’)"  
conn.Execute(SQL)

Response.Write(SQL) \<-- This works but there’s no data in the string

%\>

I’m using what Kirupa suggests:

on(press){  
loadVariablesNum("…/myForm.asp",0,“post”);  
}  
which produces nothing except inserting a row in the MDB database  
or

on(press){  
getURL("…/myForm.asp",0,“post”);  
}

which does the same as above.

Any thoughts?

Peter