relative hyperlinks

[maynard00]

Hi guys,
I'm using Access 2007 and I have a lot of hyperlinks to pdfs in my db.
Some forms use vba code to manage them, so Application.FileDialog(msoFileDialogFilePicker) and I can handle the path and delete the absolute part.
But in some forms the user edit hyperlinks directly and open it directly.. so I cannot change it.



is there a solution?
Thanks a lot!
m

[ItsMe]

But in some forms the user edit hyperlinks directly and open it directly.. so I cannot change it.

What are you trying to do? What is your objective? If the User can change it why can't you?

[maynard00]

I want that, if the position of the db changes, all the link still work.
now all my links are absolute..

[ItsMe]

Store the path to the PDF files using the Universal Naming Convention (UNC) vs. Using drive letters and mapped drives.