Results 1 to 6 of 6
  1. #1
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102

    Viewing PDF's in Access Database on a Microsoft SQL Server.

    I have a database that has been operating fine on a particular SQL Server.
    One of the features of the database is that you can view various PDF's that are linked to various fields in one of the tables.


    the way it works is when you double click on button the PDF that is in the Bound Object Frame opens in Adobe Acrobat DC and this opens in front of the db form to view. When you close the PDF you are returned to the Main database form.
    I have placed this db on a new SQL Server, now when I attempt to view a PDF it works for the first file, like above, but when trying to view a second PDF Adobe Acrobat does not open to show the PDF.
    Any thoughts on what may be causing this? I have check all settings for both Acrobat and the Database and they are the same on both servers.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    You have PDFs embedded in Access table? Embedded files use up Access 2GB size limit. Advise to leave files in external folder location.

    PDFs can be viewed within an Access form via WebBrowser control. Although I read there are problems with this in Access 2016.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I think you need to inspect the code behind the double-click event and the module for the form that contains the bound frame to see if you spot anything there (maybe some paths that don't exist on the new server).

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    The PDF files are not in the DB, they are in a separate folder with a link.

  5. #5
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    Figured it out, it was a time delay setting in Acrobat Reader. Everything is now working fine.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    For info, you can open PDF files in Access using a Web browser control. No need to open an external app such as Acrobat Reader to do so.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-25-2019, 12:33 PM
  2. Replies: 0
    Last Post: 05-11-2017, 11:32 PM
  3. Replies: 5
    Last Post: 06-12-2014, 11:51 AM
  4. Replies: 2
    Last Post: 04-23-2013, 12:44 AM
  5. Replies: 1
    Last Post: 09-13-2011, 01:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums