# Opening database from flash MX **URL:** \ **Category:** flash\ **Created:** [April 10, 2003, 3:17pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897 "2003-04-10T15:17:38Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![wiserd](https://avatars.discourse-cdn.com/v4/letter/w/57b2e6/32.png) [@wiserd](https://forum.kirupa.com/u/wiserd)\ **Post date:** [April 10, 2003, 3:17pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/1 "2003-04-10T15:17:38Z")
Hello all, We’ve designed a training course in macromedia Flash MX, and a test in Microsoft Access (MDB) (so that the test could reside on an intranet server. Shared Objects wouldn’t work because of this requirement). Anyway, I’m having trouble getting folks to open the database from Flash through an FScommand, and a getURL command works on some computers but not on others. If I could transform the database into an executable of some type, this could be readily opened by flash. So here’s my question… Any idea what I should do? How difficult would it be to use director as a ‘wrapper’ so Microsoft Database Test (already designed) would open on any computer? What would be involved? I have Microsoft ODE tools 97, if that’s any help. Any advice would be appreciated. We’re stuck on the 5 yard line for this project with everything else done, but we have no test, we’re in trouble. Thanks! ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [April 10, 2003, 4:29pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/2 "2003-04-10T16:29:17Z")
why go throught all that? Why not just use PHP to make the connection to your database? ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [April 10, 2003, 9:55pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/3 "2003-04-10T21:55:47Z")
Can I do that? My database is not connected to the internet in any way shape or form. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [April 10, 2003, 10:03pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/4 "2003-04-10T22:03:23Z")
then no. you would probably need to use a compiled language like C,C++ or basic to access the database… ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [April 12, 2003, 11:38pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/5 "2003-04-12T23:38:39Z")
Flash is a “closed environment” and the only “exit” that I know is from LoadVars and XML variables. You can’t access local ODBC from Flash. It’s like Javascript, while being more restrictive than this language. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [April 13, 2003, 7:34am UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/6 "2003-04-13T07:34:59Z")
I believe I read that if the database is on a “server” it should be accessible from an intranet via php … intranets are not nec. “local”… (?) … ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [April 13, 2003, 5:39pm UTC](https://forum.kirupa.com/t/opening-database-from-flash-mx/17897/7 "2003-04-13T17:39:38Z")
Make a distinction between “local” and “server”. In the programming world something local can be directly accessed (ie. a local variable). In the case of Flash MX, you must use a server service to access a db. Accordingly, you could have a webserver on your own machine (with PHP) and access your data from a local Flash application. - The webserver, the db and the flash application are local TO the computer.