Microsoft Access as a database

programming flash
1

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…

2

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