Uploading PDf file

[danny123]

Hi there,

My user want to upload the PDF files to the access database using the access forms. First of all is it possible? If yes then how can i do this?

Thanks alot
Danny

 

[Moniker]

You can store external objects ("upload") in Access 2007, although it's not recommended because the DB will get huge fast. Instead, you store a link to the external file that, when you click on it, will open the external file in the appropriate application (Acrobat Reader, for example).

 

[GPatters]

I'm still searching the forums, so i may find an answer elsewhere, but how do you go about setting up a link that will open up a .pdf document?

I want to have a command button that will open up a .pdf document, but I don't know how to set up the link.

 

[DCrake]

Simple Software Solutions

Hi

I have proven code that takes a file, pdf, doc, etc and converts it into long binary data and stores it as a blob in an access field. When the user select a customer it lists all documents in a list box that have been saved. The user can click on the name to open it, upon which the blob is rebuilt as a document and is opened in its appropriate format. If you would like a sample of the code let me know.

CodeMaster: