Checking for Network Connection?

[Brian Shafer]

Hello,
I have a backend/frontend setup. The front end tables are
linked to the tables on the server. If the network goes
down I would like know. What is the best way to test? I
figured before I would try to write the data to the table
return an error from a function. That way I can store the
data locally until I see the function tested again and
return ok.

Thanks,
Brian Shafer

 

[Lancer]

Man, I can think of several ways.

1. open an empty recordset (select myelements where key = something that
won't exist If the set returns good you have data AND you don't need to
open the set for input because it's already there.
2. Check to see if the file is there (Dir())
3. Open a ini type table on the back-end.

Hope this helps.