Storing, recalling, and printing various file types in MS Access 2010 data base as OLE or Binary
Posted on 2011-10-21
I'm currently workling in MS Access 2010 to develop a rather simple datebase to collect information on manufacturing approvals and inspections.
I have my basic DB and forms, however I want to use the DB to store some common forms which would print based on a check box selection on a form.
I undrstand the OLE takes up quite a bit of space, however I only have 8-10 common forms. The bigger pricture however is we may need to store a number of prints in PDF format. This task would be large and have hundreds of documents.
I can figure out how to put an OLE object into a table, however how do I then recall it and print it? Preferable as a hidden task.
Also, I saw a refernce on teh MS website for BLOB read and write functions, however it was for Access V1 or V2. Anyone have any current code or sample db to do something similar?