Storing pdfs in access database Through C#

Question

Hi I am a new programmer and am trying to develop a software that will enable storing of old documents from a large company as pdfs in a access database as well as 3 other key fields that will enable to search through the database for each document. Through my research I found that it is possible to store the pdf directly to access as a OLE binary file and i have managed to store it into the database but I am unable to reverse the process to retrieve and open the pdf document. Is it better to store the pdf in a folder and store a pointer to the document into the database and if so how do you store the path pointer into the access database from a Windows form using Visual C#. Thank you for your attention

Abhay Shanker · Answer

below link can be helpful http://mbip.hubpages.com/hub/C-program-that-interfaces-with-MS-Access-Store-data-text-image-in-an-Access-database-file

Derek da Graca · Answer

Thanks for the link. It was helpful. I've realized that the only difference is the size of the database which is not really an issue for me so i prefer to store the document directly into the database. Now I need a code to retrieve it because it saves the pdf as a binary file in access but I cant open it from there because of an OLE server error message I get. How can I retrieve the document from the database and show it in a windows form or load it in Pdf viewer