Results 1 to 6 of 6

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

  1. #1
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    101

    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
    48,612
    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 Expert
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    928
    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
    101
    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
    101
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,952
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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
  •  
Tech Forums: Microsoft Office Forums