Export .PDF Attachments

[jschlapi]

Hello,
I have a database that stores attachments (not too many - 150 total). I am not familiar with VBA code - I only know enough to be dangerous. I've heard there is a way to export all my 150 .PDF attachment to a directory on my C:/ drive.

My database name: Property Information Database
My Table containing attachment: Property List
Attachment field name: Attachment

Is there code that I can attach to a command button that will export all my .pdf attachments to my C:/ drive?

Thank you,

 

[Micron]

I've never stored attachments in an Access table (I don't believe in the idea) so I've never used code to put them in, and certainly not to copy them over to a directory. If they're in a table, chances are they exist in a folder somewhere? I'd explore that possibility first since AFAIK, what you want to do is no simple task.

In a table, they exist as a special form of data which you cannot simply save so I think solutions for this task are rare. Suggest you open them one by one and simply save. You should find that if the native app stays open, the folder location may be retained, or you can set it in the program options so you don't have to continually navigate there. Take a look here and you'll see its not simple: How to export out the OLE object content to a folder (c:\temp) - Microsoft Access / VBA