How To Set Absolute Path vs Relative

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having a little bit of a kanondrum. I am loading pdf files to a dbase hyperlink field locally. I can set relative path no problem. This is good for portability.

However, I also want to upload the dbase to my web server whereupon the realtive links fail? Shoudl I have two fields in the db, one hyperlink and one OLE? Maybe if I could just figure out how to display the full path (absolute) in the table so I can edit the path when uploading to web would be great but I can't seem to get access to display the full path. I used to be able to do this. Thanks.
 
If you want the database point to the URL on the Internet, you shouldn't
use relative links that you used on the workstation locally. Replace
them with the http URL. I am not sure why would you want to use OLE
here. Clicking on the internet URL pointing to a PDF will open the
default brouser with the Acrobat plug-in and display your file.
You can easily change the path by running an UPDATE query on your table:

UPDATE MyTable SET PDF_Path = "http://www.myserver.com/pdf" & PDF_Path

where PDF_Path is the field containing the relative path if it is the
same or simply the filename.
Pavel
 
I can relate to this. I support a customer who has 1.5 Gb in scanned
PDFs. In the database, I maintain the page references to documents and
extract pages and serve them upon request. Serving the entire PDFs over
the net is unthinkable - they can be 150 Mb apiece. The only reasonable
way of doing this is using server side page extraction.
I didn't have it in my heart to make the customer scan each document in
a separate PDF - they are all scanned randomly in large PDFs.

Pavel
 
Back
Top