Connecting to an ACCESS database in MX 2004

[CNL83]

I have been reusing this application I downloaded from FK. It lets you interact with an Access database. Well, just about everything that Im doing interacts with an ACCESS database. There is a huge line of code just let it read the records. Are there any books or something that can show me a shorter way to read and write to the database?

P.S. I have MDM Studio so if there is direction there you can point me that way.

[dgrigg]

What is the app you are using?

Are you wanting to read/write the information between the database and Flash?

[CNL83]

I dont know the name of it, but yes thats what I want to do.

[dgrigg]

Post a sample of the code that you are using to send/receive data from the database so I can try to figure out what you have and possibly what you need.

[CNL83]

It was to long to post, so here is the zip.
www.gulottas.com/events.zip

Its just to long, surely there is an easier way.

[dgrigg]

If you are wanting to connect to a database with an offline version of a Flash movie (ie a projector file that runs locally on the machine it is located on, which is what the app does that you have) using the FSCommands is about the only way to go. The FSCommands let you access the computer's OS API's to setup ODBC connections etc to allow a connection with the database.

If you want to run it through a website then you can use a variety of methods to connect to a database. You setup a DSN to the database on the server and then you can use ASP, PHP, Coldfusion or some other server side scripting language to connect to the database and pass data back and forth. You can use Flash Remoting, AMFPHP, PHPObject, loadVars or some other method to get the data from the server side to the client side.

From a coding viewpoint the web way looks much cleaner when looking at the actual SQL code but then if you need to application to run outside of the browser this is not an option.

[devnull_2k]

You could write a web service and have a Flash projector file connect to that. You'd have to write a policy file, but you could just do an

allow-domain="*"

and it would allow all projectors to connect to the database. Kind of insecure though.

[CNL83]

anybody have a source file of that service?