Flash and Microsoft Access Connectivity on CD ROM

[thegentleman]

Is it possible for Flash to read in data from an Access database whilst both are running from a CD. I appreciate that data could not be written to the database but could it be read?

~tg

 

[billwatson]

flash alone cant speak to an access db

however you can embed your flash movie (.swf) in a high level language (eg vb) using the ActiveX component, so you let the high level language do the database stuff and you display the
result in the flash movie

an alternative might be to have the db content output as an xml stream that flash can read

may well be third party tools available that can do the job eg lpflashex

 

[thegentleman]

Thanks for the response bill, I have a couple of further questions though:

This particular software tool will be designed to select a subset of records from an Access database, and then pass this subset (or totals from fields or similar) to the Flash for graphical display. The selection can be in whatever technology we want – if this were a web app then it would just be an ASP form. But we have to run this from a CD ROM so no application server is available.

Can the VB run an SQL command? I’m assuming it can. So it could then send the info to the flash module for display. And am I right in assuming that the VB would not need an application server to run on? Can the whole thing run in HTML?

~tg

 

[pixl8r]

A VB application will not use HTML at all. The complied VB app will be an executable (.exe) with a Flash movie embedded in it.

 

[billwatson]

might be an even better idea just to use flash for the web side and director for the cd as director can read access files

http://www.15seconds.com/issue/010605.htm

for flash

http://www.director-online.com/buildArticle.php?id=953

director