How To Set Absolute Path vs Relative

[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.

 

[Pavel Romashkin]

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

 

[Pavel Romashkin]

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