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?
-
-
Have you tried using Uniform Naming Convention (UNC), such as:
Code:\\ServerName\VolumeName\File (*.mdb/*.accdb)
-
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.Comment
-
Post what you are referencing the Path by.Comment
-
\\us.realty.ds\ rfg\NJ02\SHARED 2\nmg\secure\Re al Credit Financials\Real Credit\Tracking Folder\Credit Analytics_.mdbComment
-
Can you execute Credit Analytics_.mdb directly from Explorer?Comment
-
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.Comment
-
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.Comment
-
I tried removing the drive mapping and put in the address when I was linking the table. Same error.Comment
-
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)?Comment
-
I've tried placing the link in Excel and it works.Comment
-
Excel doesn't even have linked tables. What do you mean?Comment
-
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.Comment
-
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).Comment
-
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.Comment
Comment