Linked Tables in Microsoft Access

I have a MS Access table linked from a database on a shared drive.  When I go to link table manager, I see the path is the drive letter assigned to that drive.  I need to send this out to users who may have the drive mapped to different letters.  How do I set this up to use the real path:

\\server1\Quote files\Updates
Marilync1266Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try this
start > computer
right click on the right side of the window and select Add a network location

choose a custom network location, Next

in the add network location
type
\\otdx04\field&Market

click next  

0
 
Rey Obrero (Capricorn1)Commented:
in the link table manager
select the tables
check the box always prompt for new location
click OK
then select my network places and locate the shared drive
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
" How do I set this up to use the real path:"

I highly recommend you (or users ) do not user Mapped Drive letters.  Instead, use the Full UNC Path ...

\\SomeServerName\ .....

mx
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Marilync1266Author Commented:
I'm  not sure how to point to the network path and not the mapped drive letter
0
 
Rey Obrero (Capricorn1)Commented:
Marilync1266,

did you read my post ?
0
 
Marilync1266Author Commented:
Hi capricorn1,

Yes, I 'm trying to locate "my network places"
0
 
Rey Obrero (Capricorn1)Commented:
what OS are you using?
0
 
Rey Obrero (Capricorn1)Commented:
can you post the image of the "Select New Location ..." window
0
 
Marilync1266Author Commented:
I'm on windows 7.  Here is a screen print
Table-Links.jpg
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Click the Network icon ... and drill down ...

mx
0
 
Rey Obrero (Capricorn1)Commented:


Netwok Places in windows 7 is Network
0
 
Marilync1266Author Commented:
I had tried that, but for some reason the network drive is not listed - I guess I will need to talk to our network people
0
 
Rey Obrero (Capricorn1)Commented:
<the network drive is not listed>

you will not be looking for a drive


look for the server name and shared folder name
0
 
Marilync1266Author Commented:
sorry that is what I meant.  I'm looking for the server name "otdx04" and it is not listed in the list the full path is \\otdx04\field&Market
0
 
Marilync1266Author Commented:
thanks so much it worked!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.