Easier way to re-connect Data Import

K

Kernow Girl

I have set up a SS which is connected to an Access MDB file. (Data/Import
Data/ Data Query) It sits out on the network and is copied to the C Drive on
each workstation to use. The MDB is on a Shared Data drive - drive G: My new
boss just happens to have different Network connections, so her drive G: is
different - so I had to re-connect it to the data source on a different
Network Drive. It took me some time to fiddle around and do it so I just
wanted to know how other folks re-connect. Is there an easy way? Thanks for
any input.

Dika
 
R

Ron Coderre

When you make a workbook public, it makes more sense to connect to other
servers using the Universal Naming Convention (UNC) instead of mapped drive
letters. Drive letters are specific to individual computers, whereas UNC's
will always be the same, regardless of the machine.

Sample UNC reference:
\\ServerName\DeptFolder\MyFolder\myAccessFile.mdb
(all users will find that file)

Versus:
G:\MyFolder\myAccessFile.mdb
(Only users with a G-Drive mapped to \\ServerName\DeptFolder\ can access the
file)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
K

Kernow Girl

Hi Ron - thanks for your answer, and yes, I would normally use the UNC. In
this case however, I have no access to the network setup and they are good
enough to keep me out of all the 'shortcuts' I know and love. Not that I'm
complaining, this is a huge network and I'm actually glad they have done such
a good job of security. However, it makes some of the things I do a little
more difficult. Thanks again. Dika
 
Top