Jim DeMarco
Jdemarco at hshhp.org
Thu Jun 19 09:01:27 CDT 2003
Bruce, I'm not familiar with network APIs. Can you point me to any reference material? Someone suggested pinging the server but I'm not sure how to do that in VB/VBA. Thanks, Jim DeMarco -----Original Message----- From: Bruce Bruen [mailto:bbruen at bigpond.com] Sent: Thursday, June 19, 2003 9:35 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] detect network You could either use the network API calls to get the network connection information or presumably when they are connected there will be a network path name you could try to access to see if its connected. The network path is probably the QAD method. Hth Bruce -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco Sent: Thursday, June 19, 2003 10:33 PM To: AccessD (E-mail) Subject: [AccessD] detect network We've got a data collection application that will be run on disconnected laptops. At least once a week the laptop users will come in to the home office to dump the data they've collected into our central SQL database. Does anyone have any code that will detect that the laptop is connected to our network so we can point their connection to the central DB (as opposed to their local DB)? Or should we just try to hit the central DB at app start and trap the error? I don't want to generate an error if I don't have to. Thanks, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan ************************************************************************ *********** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ************************************************************************ *********** _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************