Hello,

is it possible to create a link unter Windows with Filemaker 5.5 oder 6 to a
remote database, so that the user can open it with one click?

André

Create a file that you place in your local machine, and create a link
(shortcut in Windows, alias on a Mac) to the file. The file will have no
fields or layouts, and will call just one script on open:

If[Status(CurrentModifierKeys) = 0]
Perform Script[Sub-scripts, External, "Main_File.fp5"]
End If
Close(This file)

....where 'Main_File.fp5' is the file, opend via Hosts, containing the
opening script in the remote system, and that opening script is the script
called.

The test for Status(CurrentModifierKeys) allows you to bypass the script's
sub-script by holding down a modifier key (Alt or Ctrl or whatever you
choose), so that you can repair or re-point the script in the 'opener' file.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance


"André Lämmer" <Andre.Laemmer (AT) gmx (DOT) de> wrote

I think you want the Close(This file) above the End If for the Status
(CurrentModifierKeys) to work.

"John Weinshel" <john (AT) datagrace (DOT) biz> wrote

André Lämmer wrote:
XP computers with, FMP 6U and 2 FMP6.

I as well, was just about to ask about this. I guess it would be done with a
file on my computer that opens filemaker and runs a script that "Opens Host"
that has the remote database, right? So I tried a very basic trial.

What I want to know is if there is a way to limit the host directory? When I run
that "Open Hosts" script, I get the local host with a bunch of random fmp files,
and the remote host with just one. I would like to just limit it to the remote
host, and specifically, only the host which has the group database, MACROFILE.
On other computers, A, B, C, and D, ABD might share MACROFILE, and BC might
share a different database, but I wouldn't want AD to see BC's database listing.

For all those local hosts files, should I just delete them?

One odd thing, Host is A with FMP6U, and has MACROFILE open. B runs script to
"Open Hosts" and sees Local Files and the Remote Files. C runs exact same script
on her computer and she only sees a blank screen and I have to add the remote
host. Why?
I thought that it might be because B was the first Guest, so I tried B first
then A, and I get the same sitch, B shows Remote only, while A shows Local and
Remote. I did the exact installation format on both computers.

One final thing, how do I make MACROFILE on computer A open during Windows
StartUp? Could I even make it run not just in a minimized window, but even make
it run hidden, sort of like how we have antivirus running and only a little icon
shows in the lower right of the desktop, by the clock. I don't know how to do
that. Any tips or a website link pointer?
--
"When the darkness comes, those who once lived in the shadows will need to guide
the lost ones."
-till next time, Jameson Stalanthas Yu -x- dolphins-cove.com
consul (AT) INVALIDdolphins-cove (DOT) com ((remove the INVALID))

John Weinshel wrote:
Why would you need the test to repair or re-point (assuming the remote file is
always there)? Why would the Key be referenced or changed in value?
--
"When the darkness comes, those who once lived in the shadows will need to guide
the lost ones."
-till next time, Jameson Stalanthas Yu -x- dolphins-cove.com
consul (AT) INVALIDdolphins-cove (DOT) com ((remove the INVALID))

By automatically calling up a script of an open file on a remote host, does that
bypass the need to choose a remote host, if there is more than one? It would be
just what I'd like.
--
"When the darkness comes, those who once lived in the shadows will need to guide
the lost ones."
-till next time, Jameson Stalanthas Yu -x- dolphins-cove.com
consul (AT) INVALIDdolphins-cove (DOT) com ((remove the INVALID))

No, it does not really obviate the need to point to the remote host. In the
dialogue box in which you select the External sub-script, you would point to
the hosted file.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance


"~consul" <consul (AT) INVALIDdolphins-cove (DOT) com> wrote

If the remote files are renamed or moved (which would include replacing
their machine or drive), the path will fail.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance


"~consul" <consul (AT) INVALIDdolphins-cove (DOT) com> wrote