#1
  1. Charge into the Knight
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Location
    Orlando, FL
    Posts
    276
    Rep Power
    13

    Question How to insert PDF file into MS Access??


    How do you insert an PDF file into MS ACCESS?? Thanks.
    Every man is a fool for at least five minutes every day; wisdom consists of not exceeding the limit.-- Elbert Hubbard
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Location
    NJ, USA
    Posts
    91
    Rep Power
    12
    I've never done it but I'm guessing you'd set the data type as an OLE Object. I don't see many applications where you'd want to do this though. A better approach might be to store the path to the desired file.
    - Walt

    Will code for food.
  4. #3
  5. SwollenMember
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    the master control
    Posts
    264
    Rep Power
    14
    consider some advice from a previous post about storing binary data in your db:

    http://forums.devshed.com/t41197/s84...57ee00e65.html

    everyone has their opinion, personally i think using a link is a much better way...
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0
    It is very simple to do. Concrete includes a 'Content' block that you can do this with. First, make sure your PDF file is uploaded. Follow these steps:

    1. Using the Content block, add your image into the content.

    2. While still in edit mode and with content block edit dialog open, click ONCE on the image that you want to add the link to.

    3. In the selector above the editor, select 'Link to File'.

    4. Select the file that you will link to.

    5. Save and publish page.
  8. #5
  9. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,026
    Rep Power
    4210
    thank you arronlee

    you do realize that the thread is over ten years old, right?
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo