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

Database Hyperlinks on Server Don't Work

P: 1
Hello tech savvy gurus! I hope someone can help me!

"Cannot open specified file" when I click on a hyperlink in an Access database when it is located on our server.

I created a folder "Document Library" on my local drive, which contains document sub-folders and the database.

For referential integrity, I designed the database with relative hyperlinks (e.g. Folder\File.pdf). The hyperlinks worked perfectly when the "Document Library" folder remained on my local drive.

To share data with colleagues, I saved the entire folder, containing sub-folders and database to our server. The hyperlinks work great for ALL my colleagues, so I know it's not the links themselves.

When I click on any hyperlink, regardless of file format, in the database on the server, I get "Cannot open specified file".

I created some Excel and Word documents with hyperlinks to isolate if it was only an Access problem. Result: same problem!

I login as "Admin" on my computer to see if it is a login/permissions issue. Result: Same problem!

I thought it might be a file/folder permissions issue from the source. But I can open the "Document Library" and each sub-folder and I can open all the documents. It's only the database hyperlinks to these documents that do not work.

I thought it may be my computer. This is where I seem to have made some headway. If I login to the network as either myself of "Admin" on any of my colleagues' computers, the database located on the server works! Yea! But why not from MY computer?!?!

I have searched high and low...I hope someone can steer me in the right direction.

Sep 21 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

En effet, pardon, :)

In fact the path to your folders from the server and from the local Machines is different!!!

In my work the path to folder "Update" in the Server is


But on my machine is:


U see the difference

I've resolved this problem connecting a netowrk drive Y that for Server is equal D:\

And on my machine Y is equal \\Server\D

So I'vnt more problems with the path!

Try it...

Sep 22 '06 #2

Post your reply

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