Flash_button to open Access

[Jack324]

Hi,
can a flash button be programmed to open_up access ?

I have a button on stage and on click it will close the swf and open up a saved access , would that be possible ?

thanks...

[calmchess]

yeah as long as the .swf is compiled into a projector file.

[Jack324]

ok, using fscommand("quit") closes the SWF,
but how do I code the button so that it opens up a saved file in Access ?...
is that possible ?

[calmchess]

on (release) {
fscommand ("exec", "someApplication.exe");
}

[calmchess]

http://www.adobe.com/cfusion/knowled...fm?id=tn_14280

[Jack324]

ok, I've read about it at the help docs and just tried it, but it doesn't work !

this is what I did,

on (release) {
fscommand("exec", "test.exe");
}
on (release) {
fscommand("quit", "");
}

do I have to call the application by its extension or just its name ,
I tried both but it don't seem to work somehow ????

did I do it right ?

[calmchess]

you have to give the full path to the application

[Jack324]

I have the file in the same folder, I've also tried it by putting the file into a folder called fscommand, how do I give the full path ?
can you show me an example or two please ?

[calmchess]

oh yeah and if you are going to close it then......use setinterval to wait a few seconds before closeing the app that way exec has time to talk to windows

[Jack324]

is it possible you can show me the button code for it ?
I have the file in the same folder, I've also tried it by putting the file into a folder called fscommand, how do I give the full path ?
can you show me an example or two please ?

[Jack324]

if you were to open an Access file with the file name "test" (I pressume its "test.mdb")
how can you code the flash button to execute that file , whether to close the swf or not ? that realy is what I'm asking to find out,

on (release) {
fscommand("exec", "test.exe");
}

or this

on (release) {
fscommand("exec", "test.mdb.exe");
}


didn't work. what's the correct way of coding it ?

thanks.

[calmchess]

i'm working on it /test.exe is supposed to work if everything is on the c: drive of your computer....but i haven't gotten it to work yet...but i'm intrested.../mydatabase/test.exe = c:\mydatabase\test.exe

[Jack324]

please let me know when you find out how it works, I've tried a couple of things but with no success, I've read the documents at the link you gave me , but it only gives brief description of it, and not only it don't work with mdb but it doesn't even work with any application. thanks ..

[calmchess]

Note: exec is not capable of opening a specific file with an application, just the application itself. One way to open files is to use exec to launch a Windows batch (BAT) file or Macintosh AppleScript file that then opens files in the desired application. A third-party tool that can open specific files on Windows without using batch files is available from ***********.

[Jack324]

what ?????????????

[calmchess]

i tell you what jack i work everything out for you tomorrow i have to get to bed right now.

[Jack324]

hey Thanks for trying to help me out anyway, I realy appreciated, thanks for your time and effort.