Connect to Access Database with Flash MX — OZONE Asylum, home of the Mad Scientists

Multimedia/Animation

Connect to Access Database with Flash MX

This page's ID: 23070

Edit Post

Who can edit a post?	The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	This question comes up quite often. Flash isn't geared towards CD-ROM development! As with any form of technology, you need to select the right tool for the job. ASP needs a special kind of processor to process the pages. There's no way you can guarantee the computer you run it on will have this (even if it's windows) unless you can install a web server on the CD-ROM. Actually, that is possible as apache friends make an AMP (Apache + MySQL + PHP) package that requires no install, and can run from a batch command, but that's defiantly overkill. I think your best bet will be to use some kind of native data format like XML. I'm sure someone has written a X-Query library for Flash, with AS 2.0 being so similar to Java, It wouldn't take long to port one over in any event. On the other hand, you could save yourself a lot of hassles and use Macromedia Director, which is geared towards CD-ROM development. You can embed Flash content in Director and there are several xtras (kind of like plug-ins for director, but these get packaged with the executable movie you export, which is what makes Director so good for CD-ROMS) that provide database functionality. Either by hooking into an existing DMBS or using an internal structure to store, manage and query the data. Personally, I'd opt to go for the Director path. Especially if this is something you'll be doing quite often, the cost of the program with the easy and speed of development will save you in the long run. If it's a one-off job, you'll save more by producing all of the data and material in-house and subcontracting to a development company who can put togther the Director CD-ROM for you. Either way you'll probably be saving a lot of time and or money compared to developing the CD-ROM using Flash alone. If it's a small (under 100 CDs) job and the database isn't "critical", then you could simply put the database online and stipulate that a net connection is required to view certain parts of the work. This may seem pointless as they could just view the website, but most people have access to the net nowadays yet if you give them a CD they'll be much more likely to look at it then say a business card with a URL. On the other hand, if this is just for 1 PC, you could simply install a web server on that PC and use it in combination with a server side language (the server will be running on the PC) be is ASP or PHP to access the database. But your second post sounded more like you were making a CD-ROM for distribution to your clients or your client?s clients... Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu