Check for file or host availability

Check for file or host availability

Hi,

I'm trying to make a script that checks if a filemaker file hosted on my office network is available or not. If it is the script continues and imports a few records. If the laptop running the script can't see the office network (the laptop is not connected to the office network) the script should stop.

What's the best way to implement this?

The File hosted in the office network is described in the External Data Sources as:

fmnet:/internalofficeservername.ourdomain.com/OfficeFile

The name internalofficeservername.ourdomain.com only resolves internally (there's a record in our internal dns server, but not on our external dns servers).

I tried using:

Open File [Open hidden; "OfficeFile"]

if[Get (LastError = 802] */ Unable to open file

Exit Script[]

Else

etc........

also tried

if[Get (LastError = 100] */ file is missing

Exit Script[]

Else

etc........

if[Get (LastError = 803] */ Host cannot be resolved

Exit Script[]

Else

etc........

All 3 attempts are not giving me what I'm looking for, even if the "OfficeFile" is not available the script continues...

What gives?

Thanks for your help!

Federico