flash mx and Access

[Navarone]

I'm working on a project where I am building several flash presentations to be used as "modules". The user will have the ability to choose a module, add images, custimize text and so on. I will need to use MS access. So I was wondering how well Flash MX works with access. Any example avaible to tutorials on this?

Thanks

[freddycodes]

MS Access will merely be your data storage facility. You will still need to use something to make it all work, like ASP, PHP, ColdFusion, Perl, or some other server-side scripting language which can talk to Access. Is it absolutely necessary to Access?

[Navarone]

Thanks

The database will be used for storing the client data. I will be using VB to develope the desktop portion of the project, and I have used Access before in the past on many of my VB projects.

[freddycodes]

Thats fine, I just shudder when I hear MS Access due to its obvious shortcomings compared to other free RDBMS packages. Anyways you can use VB for your desktop apps, you will still need to use a server-side scripting language to handle the database interaction piece of the project, as Flash cannot talk directly to a database.

[Navarone]

So let me see if I understand you , your saying that if I store my flash variables and image file names and so on in my access database, flash won't read them out directly?

Is there a work around for this? There won't be any server side scripting code envolved. The VB application will run one of two ways (haven't ironed this part out yet totally) 1) from the users HD or 2) from a cd + users HD.

[freddycodes]

You still need to get data in and out of flash, no? Flash cannot talk directly to your vb app. Unless your VB app is set up to receivce connections over a socket. Which I doubt it is, only because it sounds like its a windows app for managing data inside a MS Access database. So in short, yes you will need something to sit in between your vb app and the flash movie.

[Navarone]

Yes what I am working towrd is a windows app. So it might be possible to store evryting on the database and write out all the variables to something like a data.txt file and read it in to flash.

[freddycodes]

Yeah that might work. Or write an XML file. But if you put this on cd, the VB app might not be able to write a txt file to the hd, it certianly won't be able to write it to a cd.

[tg]

i've never done it, cause i haven't had a need to, but couldn't the flash (as an exe) talk to windows scripting host via fscommand to connect to the db that way?

[teriba]

If you include the Flash.ocx in your vb project you can send variables to the vb app from flash.

[B-Jevan]

what is that....how do u use it to send variable info from flash and to vb and than to access.

1) Flash>>VB>>Access
2)Access>>VB>>Flash

Ho do i do...that!