Good Morning All! I have a quick question...
I recently have been developing a DB to use both in the office and in
the field with laptops. I have synchroniztion and replication
programatically taken care of using JRO replication. I also have worked
out functions to re-assign the linked tables in the front-end DB to
either the local DB (on C:\) or to the network
(\\itcfcs004\xxx\xxx\xxxxx) - but I need some help in determining if
the network drive is available. Thanks!
~Garrett

If the network drives were mapped, you could use the Dir() function to check
on their existence. I don't think that Dir will work with UNCs.

For example Dir("c:\your.mdb") will return "your.mdb" if the file is there.
If not, Dir returns a zero-length string ("").
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Staats" wrote:

> Good Morning All! I have a quick question...
> I recently have been developing a DB to use both in the office and in
> the field with laptops. I have synchroniztion and replication
> programatically taken care of using JRO replication. I also have worked
> out functions to re-assign the linked tables in the front-end DB to
> either the local DB (on C:\) or to the network
> (\\itcfcs004\xxx\xxx\xxxxx) - but I need some help in determining if
> the network drive is available. Thanks!
> ~Garrett
>
>

Check what Randy Birch has at
http://vbnet.mvps.org/code/network/isnetworkalive.htm

(Obligatory Warning: Randy's site is aimed at VB Programmers. Due to
significant differences in the controls available for forms in VB and in
Access, many of his examples won't port directly into Access. Taking a quick
look at that page, though, I don't think there should be any issues)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Staats" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Good Morning All! I have a quick question...
> I recently have been developing a DB to use both in the office and in
> the field with laptops. I have synchroniztion and replication
> programatically taken care of using JRO replication. I also have worked
> out functions to re-assign the linked tables in the front-end DB to
> either the local DB (on C:\) or to the network
> (\\itcfcs004\xxx\xxx\xxxxx) - but I need some help in determining if
> the network drive is available. Thanks!
> ~Garrett
>