Using Front-End Application To Update Database

Ben Horne · May 30th, 2004, 12:42 AM

Hi all,

Is there a way I can create an application in Flash and connect it to an MS Access database that is stored locally on my system? If so, how can I do this?

Ben Horne
Madison Area Technical College - Truax
3550 Anderson Street
Madison, Wisconsin 53704-2599

-------------------------
http://community.webshots.com/user/valerian114

"There are two kinds of people in the world: Those who claim to be Flash junkies and those who actually are Flash junkies"

Dan Jallits · May 30th, 2004, 04:30 PM

As long as the MS Access database resides on your Web Server you can make calls to it using ODBC. Flash does not allow a user to pull data from other resources outside of localhost (your server machine). You find this same situation when you use MySQL (the open source database system) to supply data to a Web application.

It has been a while since I played with Flash and ActionScript, there may have been some changes in MX 2004 I am unaware of.

Best Regards,
Dan Jallits

vikas · June 5th, 2004, 02:34 AM

Hi Ben,
About 6 months back, I was struggling with a similar problem. Here are possible solutions:

1.) You are creating a Flash/Ms-Access application for a website.
Flash alone does cannot access the database. An intermediate language is required(like ASP for your purpose).
Asp will get requests for variables from flash and retrieve them from database(ACCESS).
Read flash docs for this. esp the details about object LoadVars.

You can also make use of Flash Remoting if you have the components.
By far it is the best option for high level projects.

2.) You are making desktop application for "offline" usage:
Here yo can either use VB with flash activex control freely available
or use applications like screenweaver

Hope this info helps...
bye
Vikas
[email protected]

vikas/alakh
[email protected]

Ben Horne · June 5th, 2004, 05:26 PM

Thanks for the info,

I got a little curious when you mentioned using ASP with Flash. Is it at all possible to use ASP code directly in Flash?

Quote:

quote:Originally posted by vikas
Hi Ben,
About 6 months back, I was struggling with a similar problem. Here are possible solutions:

1.) You are creating a Flash/Ms-Access application for a website.
Flash alone does cannot access the database. An intermediate language is required(like ASP for your purpose).
Asp will get requests for variables from flash and retrieve them from database(ACCESS).
Read flash docs for this. esp the details about object LoadVars.

You can also make use of Flash Remoting if you have the components.
By far it is the best option for high level projects.

2.) You are making desktop application for "offline" usage:
Here yo can either use VB with flash activex control freely available
or use applications like screenweaver

Hope this info helps...
bye
Vikas
[email protected]

vikas/alakh
[email protected]

Ben Horne
Madison Area Technical College - Truax
3550 Anderson Street
Madison, Wisconsin 53704-2599

-------------------------
http://community.webshots.com/user/valerian114

"There are two kinds of people in the world: Those who claim to be Flash junkies and those who actually are Flash junkies"

Snib · June 5th, 2004, 06:41 PM

Hey Ben,

http://www.macromedia.com/support/fl...#loadvariables

HTH,

Snib

<><

vikas · July 2nd, 2004, 02:34 AM

Dear Ben,
Sorry for the late reply,
When I said using Flash with asp, I meant that flash can access an ASP file using LoadVars/Remoting. Basicaly, Flash Implementation is a 3-tier approach. Flash -ASP/PHP- database.
Flash calls ASP/PHP Files for any db requirements or server side query.
ASP/PHP handles the server end and Database results.

vikas/alakh
[email protected]