# Access DB\>ASP\> Flash - Please Help!

**URL:** <https://forum.kirupa.com/t/access-db-asp-flash-please-help/194133>\
**Category:** Uncategorized\
**Created:** [July 20, 2006, 6:49pm UTC](https://forum.kirupa.com/t/access-db-asp-flash-please-help/194133 "2006-07-20T18:49:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Like\_a\_45](https://avatars.discourse-cdn.com/v4/letter/l/a4c791/32.png) [@Like\_a\_45](https://forum.kirupa.com/u/Like_a_45)\
**Post date:** [July 20, 2006, 6:49pm UTC](https://forum.kirupa.com/t/access-db-asp-flash-please-help/194133/1 "2006-07-20T18:49:18Z")

</div>

Greetings,

Before you read below, note that all of this stemmed form this tutorial:  
[http://www.kirupa.com/developer/actionscript/forms\_database.htm](http://www.kirupa.com/developer/actionscript/forms_database.htm)

I have created a flash movie that uses a form to submit information through ASP back to an Access DB using this line of code:

on(press){  
loadVariablesNum(“[http://localhost/web/processForm.asp",0,"post](http://localhost/web/processForm.asp%22,0,%22post)”);  
gotoAndPlay(20);  
}

What I’m confused about is how to get that data back out of Access into Flash.

I’m using the following ASP code to do what I think is the correct retreival :

\<%@language = “VBScript” %\>  
\<%  
Dim conn  
Dim strSQL  
Dim rs

lookup = request.form(“sslookup”)

set conn = server.createobject(“ADODB.Connection”)  
conn.open “PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:/Database/example.mdb”  
set rs = Server.CreateObject(“ADODB.Recordset”)

strSQL = “SELECT \* FROM contacts Where message=’”&lookup&"’;"

rs.open strSQL, conn

Do While not rs.EOF  
Response.Write (rs(“FirstName”))  
Response.Write “\<br\>”

```
 rs.movenext

```

Loop

rs.Close  
Set rs = nothing  
set conn = nothing  
%\>

And this code in flash to try and get it :

on(press){  
loadVariablesNum(“[http://localhost/web/accessForm.asp",0,"post](http://localhost/web/accessForm.asp%22,0,%22post)”);  
}

I’d like to populate text fields within flash with my data from access.

Thanks in advance for any help.:thumb: