By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

Creating links using a different server

P: 7
I am trying to set up a database for users that are located on a different server. I have a front end and back end. I am trying to link them without using a drive letter and using the drive name since various people will be using it. When I try to do links from the front end to the back end using the server location it tells me it is not accessible. I can navigate to the folder via Windows Explorer so it should not be a permission issue. What can I do to get these linked where various people can access it?
Dec 14 '11 #1
Share this Question
Share on Google+
15 Replies


ADezii
Expert 5K+
P: 8,597
Have you tried using Uniform Naming Convention (UNC), such as:
Expand|Select|Wrap|Line Numbers
  1. \\ServerName\VolumeName\File (*.mdb/*.accdb) 
Dec 14 '11 #2

P: 7
I've tried putting the path in but it tells me the folder isn't accessible or that it may be located in an unavailable location, protected with a password, or the filename contains a / or \. I know I have access to the folder because I can get to from my Windows Explorer.
Dec 14 '11 #3

ADezii
Expert 5K+
P: 8,597
Post what you are referencing the Path by.
Dec 14 '11 #4

P: 7
\\us.realty.ds\rfg\NJ02\SHARED2\nmg\secure\Real Credit Financials\Real Credit\Tracking Folder\Credit Analytics_.mdb
Dec 14 '11 #5

ADezii
Expert 5K+
P: 8,597
Can you execute Credit Analytics_.mdb directly from Explorer?
Dec 14 '11 #6

P: 7
I'm not sure what you mean by execute it from Explorer. I can open it fine on my end but the people that I built it for are on a different server. They can open the database but get an error because the links are to a letter drive.
Dec 15 '11 #7

NeoPa
Expert Mod 15k+
P: 31,186
Whenever a table is linked to a UNC address which, itself, has a drive-letter mapping, the UNC address will always be replaced by the drive-letter mapping.

However, you can get around this by ensuring that the machine you create the linked table on has no such drive-letter mapping. Either by removing it especially for the task, or finding a PC which has no such mapping.
Dec 15 '11 #8

P: 7
I tried removing the drive mapping and put in the address when I was linking the table. Same error.
Dec 15 '11 #9

NeoPa
Expert Mod 15k+
P: 31,186
As I have tried this again and found it to work perfectly, I can only assume that there is something wrong with the link that you are not aware of. It may be that different versions behave differently, but I would be surprised if that were the case, frankly. Have you tried writing to a file simply using the UNC address (outside of Access)?
Dec 16 '11 #10

P: 7
I've tried placing the link in Excel and it works.
Dec 16 '11 #11

NeoPa
Expert Mod 15k+
P: 31,186
Excel doesn't even have linked tables. What do you mean?
Dec 16 '11 #12

dsatino
100+
P: 393
slight rebuttal for NeoPa.

All of my backend tables are linked via UNC to drives that are previously mapped and the UNC has always persisted. This has been true in Access 2003 and 2010.
Dec 16 '11 #13

NeoPa
Expert Mod 15k+
P: 31,186
Now I'm confused. You're absolutely right of course (I just checked again thoroughly).

What I can't work out is how I missed it during my previous testing. I can't even get any UNC linked tables to translate automatically to the drive-letter path. I know I did test this, but I just can't see how I could have. Very weird (Blame it on age I suppose).
Dec 16 '11 #14

P: 7
I only have 3 end users. If I get all 3 of them to map using the same drive letter that I am...would that solve the problem? I am so frustrated...I'ved tried everything I know to do and even had someone else take a look at it.
Dec 16 '11 #15

dsatino
100+
P: 393
This is a shot in the dark, but it's worth a try...

Delete all the linked tables from your FrontEnd DB.
Compact and Repair your DB
Relink the tables using the UNC.
Dec 16 '11 #16

Post your reply

Sign in to post your reply or Sign up for a free account.