 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Easier way to re-connect Data Import
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 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 > 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 [quoted text clipped - 6 lines] > > Dika 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 > 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 [quoted text clipped - 27 lines] > > > > Dika
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.