By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 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!

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

THE BACKGROUND:
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".

TROUBLESHOOTING I HAVE TRIED:
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.

THANKS! MERCI! GRACIAS! MAHALO!
Sep 21 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Salut,

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

D:\Update

But on my machine is:

\\Server\D\Update

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.