[AccessD] HyperLinks

Hi Doug:

There are kind of links, the relative or virtual link, that is the kind you
have in your database and absolute links. A relative link only works from a
known position, in this case your DB is in a known position (it knows where
it is in the relative scheme of things.) When you select a hyper-link within
the database it checks it and then prefixes the hyper-link with it's
location to create the full link.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Murphy
Sent: Monday, May 26, 2003 6:02 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] HyperLinks


Hello List,

I have a question on the use of hyperlinks to point to files.  I have a
database that exists in a directory; C:\My Files\DBdirectory for
example.  In this directory there is a subdirectory holding files.  The
database has a table with a hyperlink field in it that contains the
relative path to a file in the subdirectory.  In other words the path to
a file might be subdirectory\filename.

It is my understanding that the hyperlink should contain the full path
to a file such as C:\My Files\DBdirectory\subdirectory\File name.  The
interesting thing is if I double click on the hyperlink the file will
open even though the hyperlink holds only the path relative to the
database.  Is this the way it is supposed to work or is this a feature
of hyperlinks in being able to resolve relative paths?

The reason I ask is that I am trying to extract the path to the file
from the hyperlink and do a file copy.  This doesn't work with the
relative path as you would expect.  If there is more info in the
hyperlink than I am extracting that would give the full path how do I
get to it?

Thanks.

Doug







_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com