[AccessD] detect network

Can one ask for the MAC address of the Server NIC?  Will it always be the same one?
Then tell it to connect if its there but not "connected". etc?
Kind regards,
David Hingston
_________________________________________________________________________
mailto:tortoise at paradise.net.nz
Personal Webpages: http://203.79.82.163/
http://www.engines2go.com/   Now THAT's a Search Engine!!
Simultaneously opens multiple search engine windows to rapidly find what you seek.   Works before your eyes
ALT-TAB between windows. Its FAST.  Its Exciting!  It works for you.  Have you tried it yet?
Home of Break Reminder, Clipboard Express, MP3 Detective and TimesOwn: http://www.cheqsoft.com/
----- Original Message -----
From: "Jim DeMarco" <Jdemarco at hshhp.org>
To: <accessd at databaseadvisors.com>
Sent: Friday, June 20, 2003 3:22 AM
Subject: RE: [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".
***********************************************************************************

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com