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.
+2
- Contributor
- 606 replies
-
10 July 2020
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.