My users of one of the access databases I support would like to store 1 pdf/word document for each account record in the database.
First...how would I even go about doing this.
Well, this has come back. I built a way to link a document to the database. However, they (users) want to store the document in the database because of security concerns.
They are uncomfortable with storing the docs in a folder where it can be seen, They tell me its only 1 doc per account record....in this case under 100 documents.
How would I go about storing a document in a table....
For Access 2000 - 2003 inclusive the maximum file size of an MDB or MDE file is 2Gb, therefore if your PDFs are quite large, you may want to have them in a separate database to the main one (store the primary key value of the main table and the file itself). Alternatively upsize to SQL Server/MSDE/SQL Express and store it in there.
A hundred documents will lead to a good deal of bloating in versions earlier than 2007. You can store objects such as PDFs in an OLE Object field. You can also store documents as BLOBs, which means less bloat but a little more trouble:
It would not suprise me if the number of .pdfs and/or their size will grow over time.
Have you thought about creating a folder that has limited access. (Use Windows or UNIX security to set access permissions) and then create links to that folder.
Alternately, if you're using Sharepoint, you might place the files on a secure area in your intranet.
(If you're not using Sharepoint yet, you may have access to it for free.)
Thanks for the info....
I saved a document to the table, creating an OLE object field. How can I automate opening up the document....
I can see it by right clicking -->then clicking on document open....
I'm having trouble with this. Does anyone know the magic trick. I am using an unbound recordset for the form.
I have a button with this code behind it...
But how do I bind the OLE field in the table to the OLEBound391 control on the form?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.