link table

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have link table from other MDB file.

MS Access always uses map driver name like I:\My folder\My datbase.mdb.

I wonder like may I use UNC link like \\MyServer\My Folder\My Datbase to
link my table from other MDB file.

If I can use the UNC link then I do not need worry users have different
network driver mapping.


Your information is great appreciated,
 
You can use UNCs and they are handy when everyone's drives aren't mapped the
same way. If I remember correctly, you need to manually type in the UNC.

There use to be a performance hit when using UNCs especially if the database
was way down a directory. I haven't tried using UNCs with 2003 or 2007.
 
You can use UNCs and they are handy when everyone's drives aren't mapped the
same way. If I remember correctly, you need to manually type in the UNC.
Click to expand...

Actually you can use Tools... Database Utilities... Linked Table Manager to
link via a UNC. The trick is that you need to navigate to the backend file
using Network Neighborhood (My Network Places, etc. whatever Microsoft is
calling it this week) instead of My Computer.
There use to be a performance hit when using UNCs especially if the database
was way down a directory. I haven't tried using UNCs with 2003 or 2007.
Click to expand...

Wouldn't swear to it but I believe that's a) always caused issues regardless
or whether a mapped drive or a UNC was used and b) has been ameliorated by one
or more service packs.

John W. Vinson [MVP]
 
Jerry Whittle said:
You can use UNCs and they are handy when everyone's drives aren't mapped the
same way. If I remember correctly, you need to manually type in the UNC.
Click to expand...

Inside Windows Explorer you can go to Network Neighbourhood and browse
to the server in that fashion.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Souris said:
If I can use the UNC link then I do not need worry users have different
network driver mapping.
Click to expand...

That works until the IT department decides to rename the server.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
For those with access (no pun intended) to the senior management group, you
could suggest that they "rename" the IT department ...

(Man, talk about job security, first you change the server name and break
everyone's LAN connections, then you get to go around for a week and "fix"
everyone's PC!)

Regards

Jeff Boyce
 
Hmm, you might be right on that.
Click to expand...

Of course it's correct, unless the IT department uses a logon script
that maps the drives and changes it to reflect the renamed server.

But server renames don't happen very often in any of the companies
I've ever worked in.
 
Wouldn't swear to it but I believe that's a) always caused issues
regardless or whether a mapped drive or a UNC was used and b) has
been ameliorated by one or more service packs.
Click to expand...

A mapped drive resolves to the UNC path, so if there were a
performance problem with UNC, it would cause the same problem with a
mapped drive.

I think there are a lot of people in the IT world who don't really
understand what they are doing when layout out their servers. They
rely on drive letters to hide the confused lack of structure in the
share layout on their servers.
 
Back
Top