[AccessD] detect network

Unfortunately this app will be used by a few outside organzitions as well so the routine needs to be generic.  I'm looking into the APIs that I've seen mentioned but haven't found anything on them yet.

Thanks,

Jim DeMarco


-----Original Message-----
From: Steve Capistrant [mailto:scapistrant at symphonyinfo.com]
Sent: Thursday, June 19, 2003 10:24 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] detect network


A lower tech option:

Make sure you have a mapped drive to your network with the central database.
Let's say it is drive "Z".  Should be a consistent mapping letter for all
users.
Then in your startup form, perform a test to see if you can open a file (any
file) in the target folder.  If it generates an error, you can assume that
you are not on the network.  Either way, you write code to handle the
situation (on or off network).

<code>
'Verify: File must exist
strFullPath = "Z:\xxx\xxx"
If Dir(strFullPath) = "" Then
    MsgBox "You are not connected to the network.", vbOKOnly, "Networking
Status"
    'Code here to work with remote copy of data
else
    MsgBox "You are connected to the network.", vbOKOnly, "Networking
Status"
    'Code here to remind user to synchronize if they haven't already
End If

<end code>

Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
Phone: 612-333-1311
www.symphonyinfo.com
212 3rd Ave N, Ste 404
Minneapolis, MN 55401


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco
Sent: Thursday, June 19, 2003 9:01 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] detect network


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


_______________________________________________
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".
***********************************************************************************