Open pdf document read only

[bbrazeau]

Is there a way to set a pdf document to read only when opening it? I have the following code that opens a pdf, but I also want to prevent the user from changing it in any way. No deletions, additions, substitutions or edits of any kind. I'd rather not use Hyperlink or Atachment data types either.

 
Private Sub OpenPrint_Click()
Dim PDFPartPrint As String
Dim AdobeProgramPath As String
Dim RetVal As Integer
AdobeProgramPath = "C:\Program Files (x86)\Adobe\Reader 10.0\Reader\AcroRd32.exe " 'Hard coded program executable path!
PDFPartPrint = (AdobeProgramPath & Forms![frmCustomers]![Child4].Form![Part Drawing Path]) ' Combined Program executable path and part drawing path!
'MsgBox (PDFPartPrint)
RetVal = Shell(PDFPartPrint, vbNormalFocus)
End Sub

[ajetrumpet]

setattr("path", 1)

[bbrazeau]

Thank you "ajetrumpet" for the reply. I tried implementing your suggestion several ways with no luck. Below is what I have. Could you be alittle more specific as to where the line of code should go, and what "path" should refer to?

 
Private Sub OpenPrint_Click()
Dim PDFPartPrint As String
Dim AdobeProgramPath As String
Dim RetVal As Integer
AdobeProgramPath = "C:\Program Files (x86)\Adobe\Reader 10.0\Reader\AcroRd32.exe " 'Hard coded program executable path!
PDFPartPrint = (Forms![frmCustomers]![Child4].Form![Part Drawing Path]) 'Set part drawing path!
'SetAttr "AdobeProgramPath", 1
PDFPartPrint = (AdobeProgramPath & PDFPartPrint) ' Combined Program executable path and part drawing path!
'MsgBox (PDFPartPrint)
RetVal = Shell(PDFPartPrint, vbNormalFocus)
End Sub

[orange]

I haven't tried this, but based on "ajetrumpet"'s reply and this
http://www.dbforums.com/microsoft-ac...read-only.html,
I would try
SetAttr PDFPartPrint , vbReadOnly
' you want the drawing path to be readonly - not the program path

It's worth a try.

[bbrazeau]

Thank you orange. Still allows a user to use the "Save as" command, but at least it keeps them from inadvertently altering the parent file. I've tried to hide the location of the file from the user by using the "Shell" command and hiding the "Textbox" that supplies the file location. It's amazing, the ways a DB user can accidentally screw up a DB. I guess the only fool proof way of locking down the referenced drawing would be to set server rights for the directories they reside in to read only.

[orange]

I think you could try

SetAttr PDFPartPrint , vbHidden + vbReadOnly