# Inserting data in MDB via Flash and ASP

**URL:** <https://forum.kirupa.com/t/inserting-data-in-mdb-via-flash-and-asp/245287>\
**Category:** programming\
**Created:** [November 28, 2007, 9:35am UTC](https://forum.kirupa.com/t/inserting-data-in-mdb-via-flash-and-asp/245287 "2007-11-28T09:35:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![blackjersey](https://avatars.discourse-cdn.com/v4/letter/b/4af34b/32.png) [@blackjersey](https://forum.kirupa.com/u/blackjersey)\
**Post date:** [November 28, 2007, 9:35am UTC](https://forum.kirupa.com/t/inserting-data-in-mdb-via-flash-and-asp/245287/1 "2007-11-28T09:35:22Z")

</div>

Hi guys,

I have been trying to create a database which I humbly followed by one of Kirupa’s tutorial. It is the Database Integration using Flash, ASP and Microsoft Access (MDB). I really frustrated because I can’t get it to work and honestly speaking, I have been trying for almost 2 months now. Any help would be greatly appreciated.

Here is my ASP code:

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

strRaffles = Request.Form(“raf”)  
strDiscovery = Request.Form(“dis”)  
strMarket = Request.Form(“mar”)

MyPath=Server.MapPath(“nocupdate.mdb”)  
Set conn = Server.CreateObject(“ADODB.Connection”)  
conn.Open “Driver={Microsoft Access Driver (\*.mdb)};” & \_  
“DBQ=” & MyPath

SQL = “INSERT INTO noc (raf, dis, mar) VALUES (’”&strRaffles&"’,’"&strDiscovery&"’,’"&strMarket&"’)"  
conn.Execute(SQL)  
%\>

In Flash, I have a button that has this code:

on (press) {  
loadVariablesNum("…/nocbridge.asp", 0, “POST”);  
}

I have read another forum that suggests instead using variables for the input boxes, use instance name. So I did.

I don’t know what I am doing wrong and values aren’t passed in the MDB file nor any rows are being added.

Please help as i am very near to give up on this ☹

Thank you very much.