R – Accessing a local access database from Flash (or AIR)

actionscript-3airdatabaseflashms-access

Is it possible for Flash or possibly Adobe AIR to have access to a local Access database?

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

I doubt it can be done with Flash or AIR alone (someone prove me wrong or right), but is there an option for some middle-man application to access the data base and send it on to Flash? How would this work?

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

Best Answer

To access a local Access database you would have to write some kind of service that can be called by air/flex. You can access a SqLite database with AS3 library, so maybe you can convert your access database into a SqLite database.

Related Topic