I am attempting to read photos from attachment tables in a FGDB and write them to an Access DB, where we have a workflow for report generation. I can get the photos out easily enough and write them to a folder, but I can't find the proper settings in the Access writer to add the photos.
Question
Has anyone successfully written photos to an Access DB?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2- Contributor
Hi @supaustin,
I'm not aware of a way to write attachments to an Access DB in FME; however, I think the best practice here is to store the attachment as binary data in a blob attribute (ref). To paraphrase the answer provided on the linked forum post, while attachments are supported in access, it isn't recommended due to the 2GB file size limit. Otherwise, it sounds like attachments can only be added in Data Access Objects (ref).
I would recommend using the AttributeFileReader to read in the photos as this will read in the binary data and store it as an attribute on the feature and then write it to your access database as a blob.