Convert Relative Hyperlink path to absolute

M

McWolfen

I have a hyperlink field that the user drag's and drops a file into. It seems
to be working fine IF the user pulls from the "Public" sector of their
machine, but all other locations it's pulling a relative path "..\..\". Is
there any way to convert this to an absolute address?
 
D

Daddy Bear

Joined
Aug 9, 2011
Messages
1
Reaction score
0
It seems that the Access Front end must be local to force absolute path definitions. If it is on the network then it insists on using relative locations (kinda makes sense if you read all the blurb).

I have 'discovered' this by dragging and dropping a file onto a hyperlink field, and then wishing to copy the file in the after_update event. The copy is via FileSystemObjects CopyFile method which always wants absolute paths (of course). My database (2007) was on a network share and always threw 'path not found' for the source file...until I moved it to my PC.

HTH anyone who's been fumbling around looking for a solution :cheers:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get absolute path for hyperlink with relative path 5
relative vs absolute paths for images 3
Need help using a relative path in VBA 0
Relative/Absolute path... 2
Absolute v Relative Path Help... 4
Word changing hyperlinks from relative to absolute 7
Relative vs Absolute hyperlinks 6
hyperlink 3

Top