This content has been marked as final. Show 3 replies
You'll need a 'backend' environment like e.g. JEE, .NET, PHP or the likes for this to work. Flex cannot directly talk to any database at all. I lives in a browser after all! So you'll have server side logic to connect to you MS Access or any other database, read and convert this data to XML or JSON or whatever format and then use HTTPService class in Flex to hit this 'page' and show the data it would send. If it sounds like Ajax call to you, you'll be absolutely right!
For most purposes, ATTA is right. And with MS Access, I know of no other option but to use some middleware to access the database.
However, you can use the socket classes to access server based databases directly. Someone has done some experimentation with this and has ActionSCript SQL Drivers created for MySQL.
More info here: http://code.google.com/p/assql/ and here http://ntt.cc/2008/02/01/actionscript-mysql-driver-assql-access-database-from-flex.html
Not that I'd recommend this approach, but is is possible.
While I'm spouting out at the mouth...
If you're building a web applications (Flex) that is intended to be used by multiple people at once, you are much better off migrating your database to a server based database such as SQL Server or MySQL.
If you want to build an AIR app that won't be dealing with concurrent users, you might look into converting from ACcess to SQLLite database.
Thank you very much Guys.