Strategiy needed for dealing with offline database

[crpatter]

I work for an organization that usings filemaker out in the field with over a hundred laptop computers. At the start of a shift, employees download the latest data to their laptops. At the end of the day, they upload their new/updated data.

I'm looking for some suggestions on how to detect whether or not the laptop is connected to the network.

[DykstrL]

I use an error trapping method to check for a network connection in a similar situation you describe.

Setup a script (RemoteConnect) on your server file with just one script step:

Exit script

In your remote file, as a first part of your upload script run this:

Set Error Capture [ On ]

Allow User Abort [ Off ]

Perform Script [ Filename: "MyServerFile.fp5" (myserver), "RemoteConnect" ]

[ Sub-scripts ]

Set Field [ _error, Status( CurrentError) ]

If [ _error <> 0 ]

Beep

Show Message [ Buttons: "OK", "", ""; Data: "It appears you do not have a network connection that will connect with the Server.

Check your connection and try again." ]

Close [ Filename: "MyServerFile.fp5" () ]

Halt Script

End If

If the connection fails, it will record an error code other than "0".

This is from a V6 file, but a little tweaking and it should work for V7.