Hyperlinks to Open Read Only

[Guest]

I have a form in an Access database with the following fields:

Name - eg. Michael Jackson (text field)
Title - eg. Thriller (text field)
Location - eg. C:\Album 2.doc (hyperlink field)

I want to be able to click on the hyperlink and open the document in
read-only format, (even if the actual document is not read-only).

Please can you assume that I don't understand VBA because I find it really
hard to use or understand.

I would like a quick way to do this please.

Thanks for your help.

 

[John Nurick]

I don't think this is possible with a hyperlink field, except by modifying
the Windows file associations so as to open all Word documents read-only.
Even then, once the file was open the user could modify it, save it under
another name, delete the original, and then rename the copy to the original
name.

If you replace the hyperlink field with a text field, it's possible to use
VBA to launch Word and open the document read-only. But - as above - this
only protects against accidental changes.