DCRAPACCESS
asked on
Access insert into Attachment field file from Path
Hi Experts,
I have a text field i a form. In that text field there is a full path to a file. How do i use this path to insert that file into a attachment field i a Table using vba?
I have a text field i a form. In that text field there is a full path to a file. How do i use this path to insert that file into a attachment field i a Table using vba?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are storing a few images, like a Logo, to print on reports then the Attachment data type can be very useful.
If you are want to store lots of documents (PDF, DOC/DOCX, etc) then I agree with fyed that this may not be the best method.
It all depends on what you are wanting to do which is the best approach.
If you are want to store lots of documents (PDF, DOC/DOCX, etc) then I agree with fyed that this may not be the best method.
It all depends on what you are wanting to do which is the best approach.
ASKER
Worked. Thanks
Hello
I tried the above code but it shows me error at
Set rsParent = Me.Recordset
Method or data member not found
any help?
I tried the above code but it shows me error at
Set rsParent = Me.Recordset
Method or data member not found
any help?
Although recent versions of Access do this without too much bloating of the database, you are still limited in the size of your datafile, and attachments, whether they be .doc, .pdf, .ppt, .xls, .jpg can rapidly increase that size and overwhelm your database.
Personally, I prefer to use the technique you appear to be using now, storing the path to the data in your database and then using a hyperlink method to open that file when needed. This has potential down-sides as well, in that unwitting personnel can delete the file or the folder and "break" the relationship between the pointers in your table and the actual location of the file. However, you can take steps to make the file location sufficiently well protected (and backed up) to avoid or mitigate this problem.