Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Flash (all versions)
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Flash (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 30th, 2004, 12:42 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Madison, Wisconsin, USA.
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default Using Front-End Application To Update Database

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"
__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age
 
Old May 30th, 2004, 04:30 PM
Authorized User
 
Join Date: Jun 2003
Location: Glen Ellyn, Illinois, USA.
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Dan Jallits Send a message via MSN to Dan Jallits Send a message via Yahoo to Dan Jallits
Default

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
 
Old June 5th, 2004, 02:34 AM
Authorized User
 
Join Date: Jun 2004
Location: chandigarh, , India.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vikas
Default

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
alakhniranjan@rediffmail.com

vikas/alakh
alakhniranjan@rediffmail.com
 
Old June 5th, 2004, 05:26 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Madison, Wisconsin, USA.
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

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
alakhniranjan@rediffmail.com

vikas/alakh
alakhniranjan@rediffmail.com
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"
 
Old June 5th, 2004, 06:41 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: , , .
Posts: 1,285
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Hey Ben,

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

HTH,

Snib

<><
 
Old July 2nd, 2004, 02:34 AM
Authorized User
 
Join Date: Jun 2004
Location: chandigarh, , India.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vikas
Default

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
alakhniranjan@rediffmail.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
Front end Vs Back end ricmar Access VBA 3 May 27th, 2008 02:36 PM
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Oracle back-end MS-Access 2003 client front-end Corey Access 2 February 16th, 2007 08:31 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 06:00 AM
creating Front - End anukagni Access 8 April 22nd, 2006 04:11 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.