Open pdf document read only

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

Sponsored Links:

Related Topics

Make changes to a PDF file
Portable Document Format (PDF) is a common format for sharing final versions of documents. Most PDF files are similar to read-only; they can be read but not changed.

Ole server error
My Dears,

I have a Access database which I have a record where I attached a .pdf document.
Everything is going smovely until I open the document. When I close the .pdf document give me this error:

WebControl() Access 2010 - save url in database
I have a form with a webcontrol where I need to save the url/document ex. a pdf-file in my database as an attachment.

When I ex. make a google search and find a pdf document - I can open it inside the control - no problem. and the PDF reader save functions opens too.

But I need to save the document in my database og local ex. pdf-file

Opening PDF attachments in VB from my Access Data Base
What I would like is for the entire field of attachments to read 'Open' and then click on that word open and it will open the PDF that is attached.


LastName | FirstName | OPEN | Date | Notes | etc

I would just like to click the word OPEN and have the PDF associated with that contact open.

Linking Scanned Documents (pdf)
My employer would like for a document that has been scanned on the network scanner to appear in client file.

Lets assume the file will be in PDF format in a specified folder and that the first 4 charters in the document will be the unique client ID followed by the description of the type of document. Something like 3980 Offer Letter.pdf

Can I have access evaluate that folder and only display those files that are have to do with that client in a form where only that client information appears? Also if the user clicks on the file it needs to open.

Is this possible and if so can someone give me an article or advice of what I can do to make this work.

Maybe I am going down the wrong path and there is another way to accomplish this.

I thought of hyperlinks but not sure if that would be virtual

How to handle a PDF file
I've already made an access application that does the work I expect it to do.
Now I want to make things a little faster.

I now receive by email a PDF form (or file) filled in by a customer. I open it with Acrobat Reader and then manually enter the information contained in the PDF file into a new record in my database.

Now I would like my application to read that file and fill in a new record by itself.

Would somebody know how to do this or at least put me in the good direction

Inserting a pdf or word document into report
I have a mulitple page report. I need to insert into it PDf or Word documents. I cannot find a way to import these within the report tools.

Does anyone have any ideas how I can do this. Basically we are are wanting to put certificates within the document.

Long Binary Data (type) to PDF in table
Access 2007) using VBA I need to convert "Long binary data" type to pdf "Adobe Acrobat Document" in an OLE Object Access table.

If I drop/drag the document into the table I get the "Adobe Acrobat Document" type that allows me to double click to open.

If I copy the same file using VBA, the "Long binary data" type doesn't allow me to open with double click.

Any ideas how to convert the file to a PDF format during, before, or after I copy the file to the table? I don't see any way to cast the file to be an OLE Object of PDF type. Any help - great appreciated.

Code snippet.
Dim curDatabase As DAO.Database
Dim MyTrackingTable As DAO.Recordset

Set curDatabase = CurrentDb()
Set MyTrackingTable = CurrentDb.OpenRecordset("TrackingTableName")

MyTrackingTable("Report") = PathToFile + "DaileyReport.pdf"

Multiple Users Can't Read
Our database is located on a central server.

The database allows a user with permissions/full access to open the database, but if it is already open by one of those users it does not default to the usual read only document.

This message pops up. "Could not lock file" and then it goes to the Access home page where you end up when you open the Access program from scratch.

Any ideas on how to get it back to just having read permission when someone is using the database?

Displaying PDF files using VBA in access 2003
with code to open externally saved PDF files from a button on an access formn using VBA.

My pdfs are located in a folder on the c: drive

eg. c:/jobpacks/a/alfreton/yyy.pdf
/b/barnsley/xxx.pdf etc

All I want to do is open them and display them on the screen, I would then like to email them as an attachment

Attaching a .pdf document
I'm new at using MS Access and I'd like to attach a pdf document to an existing MS Access 2003 database. Can you tell me how?

Checking if a document of the same name is already open prior to trying to save it again
I am trying to write VBA functions to act as error handlers for a database.

The database form allows you to select certain fields and by clicking a button it automatically generates a word document for the user, opens the document for viewing and saves as a file name in a predetermined folder.

The problem I am having is that if the user selects the generate report button twice without closing the word document first it crashes due to the document being already open.

Is there a way to check to see if the document is open before it tries to generate the report again and alert the user that the document is already open?

OLE server error for pdf files embedded in Access 2007
I am using Access 2007 that has embedded pdf files that were created in Adobe Acrobat. When I open a pdf, I receive the following message "The operation on the Acrobat document object failed. The OLE server may not be registered. To register the OLE server, reinstall it." Once I have opened the file and get this message, I can no longer open the file

Access Report exporting and merging to Word/PDF
I try to Export and Merging Access Reports, some in table-format = with lines, and some with graphics. But I only can generate text documents.

What do I have to do to export these reports to Word in the right format? And if I merged the generated document. Is it possible to save this document in the right format as a PDF-document?

ActiveDocument.SaveAs strOutputFileName, wdFormatPDF, .

Creating relative hyperlinks to .pdfs with Web Browser Controller
I'm displaying .pdf files using the Web Browser Controller using the absolute path;

="R:\Certificate of Veterinary Project\" & [Document] & ".pdf"
([Document] being the file name)

I'd like the path to be relative so I can burn this to a CD.

I tried "./" & [Document] & ".pdf" without success

Hyperlink and PDF
Version of Access used - 2003
Plan - Hyperlink field in a form which would pull up a saved PDF of a saved invoice.
Problem - added Hyperlink - used edit hyperlink function to look up and add PDF file which is saved on PC to the field but the PDF will not open. Tried the same with a word file - it will open.
Question - Can Access 2003 open a PDF file? If so - how can I fix this. If not, will I have to reformat the file to be JPeg or something like that?

Export to PDF Document Format
Contrasting to Access 2007, in which you need to install add-ins to export database. Access 2010 offers option of exporting database in PDF (Portable Document Format) and XPS (XML paper Specification) formats. Now with Access 2010, you can export datasheet, Forms and Reports to a .pdf or .xps file, it enables you to spread information in an easy-to -distribute form that contains all formatting characteristics.

Link PDF on form
I have some PDFs named like "PB_(ID).pdf" in a fix directory like / (root).
I have a DB in the same directory and the ID of my data is equal the pdf document.
My question is how can I create a dinamic link in the form to view a PDF file? Like this: I find an client for your ID: 12345. In the form with more details from "12345" I have a button that is a link to PB_12345.pdf. I know that I can make one by one, but I have a lot of IDs

Report Renaming in Access
I am printing a report from access in to a PDF document using a freeware called Cute PDF Writer. My requirement is to set the PDF name as a custom one taken from the report and should be saved.

In present scenario it is taking the report name as the DEFAULT name. for example my report name is SALES and when I print the report its coming default as SALES.pdf. But I need Alan Bakes.pdf where Alan Bakes is the organisation name which is there inside the report as a textbox.

Linking files to Access
I have been asked by my employers to create a document retention system.

They recieved two documents from the customer which are scanned in as two separate PDF files. The PDF files are stored on the scanner units memory.
The scanned documents are accessed from a web interface.
The PDF will be downloaded and then saved to a folder.
The user will then link the file in the database by entering the file path into a field. (how?)
VBA code will be executed to rename the file, move the file from the original path and dump it in a central folder.
A shellexecute script will be used to open the files from within access. (this is covered)

So how do I go about llinking the files? I have never used access as a 'document server' before. Is there a way to have a file upload window where the user can navigate to the file? I can do the renaming bit all fine, just need to actually get the files path