Open scanned document from access form

[Nancy Connoyer]

I have query that is displaying a scanned document path that I am pulling from an sql database:
Path: Simmons\dfs\sca nned\MIS\FirmDB \FileStore\Tria lTeam\MedicalPa thology\jtvlrze c.jmw.pdf
I am linking to this query in Access and want to display this path on a form in Access so the user can click on the link and open the PDF.
I can see the path in my field on the form, but when I click on the path it does not open the pdf.
The path is not stored in a table in access, It is only availalbe through the odbc link to the query in the sql database.

[Rabbit]

That's not a fully qualified path.

[NeoPa]

What that means in real terms is that the path resolved would be relative to the current folder. EG. If the current folder were "F:\My Documents\Datab ases\Bytes", then the folder where it would look to find the file would actually be "F:\My Documents\Datab ases\Bytes\Simm ons\dfs\scanned \MIS\FirmDB\Fil eStore\TrialTea m \MedicalPatholo gy\". I doubt this is what you were expecting or intended.

[Nancy Connoyer]

if I copy and paste this into my windows explorer: \\simmons\dfs\s canned\MIS\Firm DB\FileStore\Tr ialTeam\Medical Pathology\I see a list of files, with one of them being: 5rqrtvbp.d3i.pd f, the one I need to open.

[NeoPa]

And that's a perfect illustration of the difference between a fully qualified path (in post #4) and one that isn't (in post #1). Well done. You understand now.