Hello,
I have put together an Access DB, but am getting some requests to place attachments in the table and/or forms that I have set up. I haven't been able to find out in my web search.....is this even possible????
Mostly word or .jpg attachments are being requested. Any ideas?
Re: Add Attachments To Access Database
What do you mean exactly?
Re: Add Attachments To Access Database
Is it possible to provide attachments into my database table or forms? If so, how??
Re: Add Attachments To Access Database
Try creating a new table and using the "OLE Object" data type.
The help files are quite good on this subject.
One thing to watch is database size. If you embed the files in the db it can quickly grow.
HTH
Carl
Re: Add Attachments To Access Database
My advice is DO NOT insert OLE objects in teh database. The file size grows far to quickly. Instead store a string that provides the filename and path of the 'attachment'.
For pictures you can display these by using teh ONCurrent Event that will update the source for an unlinked image on the form. If you want to open a word document on your form then you will have to insert a word document object and again update teh source. I have avoided doing this in teh past and instead used teh stored filename string to change a hyperlink. If the user wishes to read the 'attachment' then they click the hyperlink and Word is opened without you having to determine taht Word was required.
Good luck,
A.
Don’t have an account yet? Register yourself now and be a part of our community!
