Import PDF drawing to Database and Dispaly PDF on Access Form

[drpkrupa]

I got new task where I need to design one access form. The page has two sections.
Section 1: I want a give option to user where they can click on button and select PDF file by using Application.FileDialog. After selecting the file, I want a transfer the PDF file to the Access/SQL database and store the pdf file into the database.

Section 2: I want create the image box or any other object where I can display the uploaded file from Access/SQL database.

User need to upload the file to database table and then pull the imported file from database and display as picture on image box or any other control box.

I have done browse the file by using Application.FileDialog and import the selected text file to Access database. I haven’t transferred PDF file to database and pull the file display on screen. Can anyone help me out here.

 

[Mr. B]

drpkrupa,

As for "transfer the PDF file to the Access/SQL database and store the pdf file into the database": I would suggest that you never even try to actully save any file to a database. This will only server to bloat the database. Instead, just store or save the Path, including the file name, to the location where the file is already stored (saved).

As for displaying a PDF document on an Access form; the link below was posted by Access MVP Arvin Mayer, MCP, MVP and should be of some help:
http://www.pcreview.co.uk/forums/thread-1105623.php

HTH

 

[drpkrupa]

I am using sql database and sql table are link to access database. I want a store pdf file into access database. We are storing path as of today. We have an issue because the files get transfer during approval process. When we receive pdf file for customer we added into pending folder and upload path to SQL table. As soon as file approve we move them into approval folder and if we got new revision approval then move file from approval folder to archive folder. During this process we borke the link. If i store the file in SQL then we can easily retrive at any point of time.

I have done thru ASP.NET but never tried to Access database. Is there any sample that i can take a look.

 

[Mr. B]

Using ASP.net you would upload the PDF docment to a specific folder on the server. You would still be storing the path, not the actual file.

What process are you currently using to move the PDF documents from one folder to another?

 

[DCrake]

This is very similar to ta thread creted on the same subject. Refer to that for instructions. Please do not double post.

David

Demo