We hyperlink thousands of PDFs without problem. A couple of things to note:
1. If the PDF filename in the Access field has spaces, you need to search and replace the spaces with %20.
2. You need to insure that the files are not moved from the original directory and that the directory is not renamed.
3. There are two programs available from pcmag.com that will help with bulk entry of hyperlinks. FileGrab (create a list of all PDFs in a directory) and MultiRename. You have to subscribe to pcmag.com downloads for $20 but well worth it.
Hope this helps
Originally Posted by Trini Gal
I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."
My database is still Access 2003, I haven't upgraded it yet because I was
only recently upgraded to Access 2007. I have listed our systems and the
annual testing results in .pdf format (hyperlink datatype in the table). I
have given the users read only access to where the files are stored and have
listed it as a trusted location. I would like when they click on the system
ID, the report opens up and they are able to print.
My user keeps getting the above reference table.
Can someone let me know why this is happening please?