View Single Post
  #5  
Old May 19th, 2010, 09:51 PM posted to microsoft.public.access
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Access hyperlinks ignore file associations

=?Utf-8?B?Y29mZmVudA==?= wrote
in :

Using Windows XP Control Panel / Folder Options / File Types, I
have set the "pdf" extension association to another pdf file
viewer than Adobe Acrobat. This works fine in all programs other
than Access. For example, if I double-click on a file with a pdf
extension in Windows Explorer, it opens it with the third-party
viewer. However, if I create a hyperlink to that same file in
Access it is listed as "Acrobat Document" and if I double-click
it, Access ignores my file association and opens it with Adobe
Acrobat. Is there a way to get Access to honor the Windows file
associations?


I would look carefully at the defined file associations. My guess is
there's something else defined that is overriding it.

You could also test what the apiShellExecute API code does with it:

http://www.mvps.org/access/api/api0018.htm

The other thing that's important is to realize that Access hyperlink
fields are problematic, and in my opinion, not worth the trouble.
It's just a special case of a memo field (in order to handle links
longer than 255 characters), and I tend not to use them at all,
precisely because of this kind of unpredictability, as well as the
complications of editing them.

I can't say that converting your hyperlink to a plain memo field
will fix the problem, but it is something I'd do, anyway. It does
mean you then have to write code to open the hyperlinks, though. But
that also gives you control over what happens.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/