How to set Hyperlink Base for networked environment?

[deko]

I have a subform in my Access 2002 mdb that holds Hyperlinks to documents
(.pdfs) that are associated with each record in the database. The datasheet
subform is simply a list of Hyperlinks to previous invoices for each client.
The problem is that other workstations on the LAN cannot open the documents
(they can connect to the database okay).

The workstation on which the database resides (MainPC) opens the documents
without a problem, but other workstations (RemotePCs) cannot. An error is
received when the remote user clicks on the Hyperlink in the subform:
"Unable to open document.pdf. Cannot open the specified file."

I have the Hyperlink Base (in File | Database Properties | Summary tab) set
to:

C:\Documents and Settings\Administrator\My Documents\Pdf

The RemotePCs have a drive mapped to MainPC -- drive letter "P". I've tried
setting the hyperlink base to:

P:\Documents and Settings\Administrator\My Documents\Pdf

but then MainPC cannot open the Hyperlinks.

Is there way to set the Hyperlink Base so all workstations on the LAN (same
IP address space) can open the Hyperlinked documents on MainPC?

Thanks in advance!

[Pieter Linden]

I think most of this was discussed within at most the last two weeks.
Store the UNC path to the file as a Text field and then format the
text field as a hyperlink in your form.... Then it's location is
fixed. Period. The only reason someone wouldn't be able to open the
file is if he didn't have Acrobat installed.

[deko]

Thanks for the reply.

So are you saying that instead of: using the Insert Hyperlink dialogue
window I should type out the UNC like this:

\\MainPC\Documents and Settings\Administrator\My Documents\Pdf\document.pdf
???

As for the format of the text box in the subform -- the Data Type of the
table field is set to Hyperlink, and the text box on the form is set to Is
Hyperlink = No. Is this correct?

The Insert Hyperlink dialogue is very helpful and it would be a hard sell to
get users to give this up in favor of typing out the entire UNC (as opposed
to browsing for the file as they do now with the Insert Hyperlink dialogue).
Could I somehow use code on the remote workstations to modify the path or
Hyperlink Base as needed? An alternative solution I was considering was to
store all the documents in question on a NAS device -- so the path is the
same for all workstations -- but this is a rather drastic measure.

PS. I checked back a couple of weeks worth of posts but did not find the
previous discussion you mentioned.

Thanks again for your comments.

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

I think most of this was discussed within at most the last two weeks.
Store the UNC path to the file as a Text field and then format the
text field as a hyperlink in your form.... Then it's location is
fixed. Period. The only reason someone wouldn't be able to open the
file is if he didn't have Acrobat installed.