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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 Architect / Systems AnalystCommented:
" 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
Marilync1266Author Commented:
I'm  not sure how to point to the network path and not the mapped drive letter
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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 Architect / Systems AnalystCommented:
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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Marilync1266Author Commented:
thanks so much it worked!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.