Question Access 2010 split database hyperlinks not working when copy of front end is moved to

[mitchell1613]

[FONT=&quot]I have built an Access 2010 split database on my computer and it functions as built. My next step was to copy it to the server at work and test it. I discovered the tables had to be re-linked and so did that. As I have read in the Access World Forums in order to function as a multi-user database a copy of the front end must be placed on the individual workstation with the back end residing on the server, however the hyperlinks in the back end will not function when the copy on the workstation is run. I simply get an unable to open "filename" error pop-up. I can run the server copy and everything functions as built. I know that the hyperlinks require all the files to be in the same folder (relative vs. absolute), but if the back end contains all the hyperlinks why does the location of the front end seem to affect the operation of the back end? More importantly how do I resolve this issue. VBA solutions welcomed or is there a macro?[/FONT]

 

[DavidAtWork]

These hyperlinks, presumably they are a value held in a field in a table, are they to a shared drive/folder location which every user & workstation has access to. Sometimes users shared drive mappings can be different even though the target folder is the same

David

 

[GinaWhipp]

In additon to what Dave posted... I would suggest you use UNC Paths. This will avoid the individual mapping differences.

EDIT: Welcome to the Forum!

 

[mitchell1613]

The "File_Path" is an "On DblClick" event that will take a user to the search for manual. The problem that I have is understanding how Access "sees" the path for the file that is hyperlinked. When I did it before I simply right clicked in the File_Path text box to Edit Hyperlink and then found the file then added it. The hyperlink is stored in a table in the Back end. Now I have moved the database to several different servers, computers and drives always in the same folder and the hyperlinks have function to take me to the requested file. My back end is password protected and the password and absolute path for the back end are a Global Constant in a Global Module in the front end. Now when I want to put it in a multi-user environment the hyperlinks do not seem to function. I have read the post on Followhyperlink (fairly new to VBA) so I need to research this more. I just don't understand how the location of the front end seems to impact the hyperlinks when they are residing in the back end in the same folder as the sub folder containing all the files.