How to Best Work On an Application Remotely

[Sprinks]

I am currently supporting and developing several split applications wherein
the backend data files reside on the server. Now that I have a laptop, I
would like to work on them while on the train, around the pool, etc., making
changes only to the front-end, but needing a connection to data.

Without getting into replication, which I'd like to avoid, is there a way I
can program the app to:

If my corporate network connection is detected, set the links to it,
otherwise, set them to my local hard drive location?

Thank you.

Sprinks

 

[Douglas J. Steele]

Randy Birch has code at
http://vbnet.mvps.org/code/network/isnetworkalive.htm that'll let you check
the status of your network connection. Once you know whether it's live, you
could use that information to decide which back-end to connect to.

 

[Dale Fye]

do a search on "refresh links"

There have been a number of posts with details on how to refresh your links
via code. It would not take much to modify these to check for the link to
your server side database, and if it is available, link to that data, and if
not, link to your local data.