Access a local access database from Flash (or AIR)

Question

Is it possible for Flash, or perhaps Adobe AIR, to have access to the local Access database?

I will have either a Flash EXE or AIR application running on the local PC (WinXP). The PC will also have a local access database. I need a Flash application to retrieve data from this Access database. How can I do it?

I doubt that this can only be done using Flash or AIR (someone proves that I am wrong or right), but is there an option for a middle-level application to access the database and send it to Flash? How it works?

Or could I read the MDB file in Flash and parse it myself? is there a library for this?

Answer 1

To access the local Access database, you will need to write some kind of service that can be called air / flexible. You can access the SqLite database using the AS3 library, so perhaps you can convert your access database to a SqLite database.

Answer 2

You cannot do this only with AIR (if there is no AS3 library to parse the access database). However, you can connect to db using an AIR - Java bridge, such as merapi .

Merapi allows developers to plug in Adobe AIR applications written in Adobe Flex Java applications running on the user's local computer.

PS: , AS3 MySQL.