|
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!
| 
