link table

[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,

 

[Jerry Whittle]

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.

 

[John W. Vinson]

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.

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.

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]

 

[Tony Toews [MVP]]

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.

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/

 

[Tony Toews [MVP]]

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

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/

 

[boblarson]

If you want a visual of what they said as to using UNC:

http://www.btabdevelopment.com/main...linktoyourbackendviaUNC/tabid/69/Default.aspx

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Souris]

Thanks millions for the message,

If you want a visual of what they said as to using UNC:

http://www.btabdevelopment.com/main...linktoyourbackendviaUNC/tabid/69/Default.aspx

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[John W. Vinson]

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

Tony

Well, that'll break all the users disk mappings as well.

John W. Vinson [MVP]

 

[Tony Toews [MVP]]

Well, that'll break all the users disk mappings as well.

Hmm, you might be right on that.

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/

 

[Jeff Boyce]

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

 

[David W. Fenton]

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

....which would also break the drive mappings.

 

[David W. Fenton]

Hmm, you might be right on that.

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.

 

[David W. Fenton]

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.

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.