# Microsoft Access as a database

**URL:** <https://forum.kirupa.com/t/microsoft-access-as-a-database/26894>\
**Category:** flash\
**Created:** [July 28, 2003, 12:40am UTC](https://forum.kirupa.com/t/microsoft-access-as-a-database/26894 "2003-07-28T00:40:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SLamaJama](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@SLamaJama](https://forum.kirupa.com/u/SLamaJama)\
**Post date:** [July 28, 2003, 12:40am UTC](https://forum.kirupa.com/t/microsoft-access-as-a-database/26894/1 "2003-07-28T00:40:14Z")

</div>

hi…  
anyone knows how to connect access as a database on flash mx? tried using php, asp n javascript…kinda confusing…anyone knows how? pls reply asap…

---

<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:** [July 28, 2003, 4:32am UTC](https://forum.kirupa.com/t/microsoft-access-as-a-database/26894/2 "2003-07-28T04:32:20Z")

</div>

In ASP its like this…  
ie. You want to send a CustomerId value to Flash Mx

Set my\_conn= Server.CreateObject(“ADODB.Connection”)  
my\_Conn.Open “DRIVER={Microsoft Access Driver (\*.mdb)}; DBQ=c: emp\access\Customers.mdb”

strSql = “SELECT CustomerId FROM Customers where  
city=‘Alanta’”

set rs = my\_conn.Execute (StrSql)

'Assumption one record is returned.  
If rs.EOF

Id= RS(“CustomerId”)

End If

'Send to Flash Mx  
response.write “CustomerId=” & Id