Verify connectivity to shared drive

[Mike Tubman]

Hello all,

I am running Filemaker 24 on Filemaker Cloud in windows. 

We have a shared drive on a server in our office. On this drive we have project folders and our Filemaker solution creates and writes to these folders when our employees are in the office and connected to the shared drive. 

The issue is that our employees are not always in the office, they often work in the field and at home. I had set up a validation script during startup that tried to import from an excel file on the shared drive and if it threw error 100 (file is missing) then is set a global field for that session saying they were remote. If remote it would create and write to the desktop and they could transfer it to the shared drive when back in the office. 

It always worked fine on my machine but now I have several employees (not all) that always show remote even when in the office. I am using filewin as shown below. I tried to switch to fmnet but that didn't work either. Does anyone know why this script shows remote when a user is in the office and able to access it or if there is an easier or at least more accurate way to test connectivity to this shared server folder?

 

Set Error Capture [On]

Set Variable [$v_folder; Value: "filewin://shared computer name/Developement/Server_Val_File.xlsx"]

Import Records [With dialog:Off; Table: DEV; "$v_folder"; Replace; Windows ANSI]

If [Get(LastError) = 100 ]

       Set Field [ DEV::xzRemote_server; "Remote" ]

Else 

       Set Field [DEV::xzRemote_server; "Server"]