Exporting Attachments

[kp123]

Hi all,

I am still very new and tentative in my use of Access (I have version 2007).

That said, I have designed and built a database that generally works, although I have (somehow) managed to avoid some of the technical coding side of things!).

My colleagues have completed records in my database and embedded/attached files in the appropriate attachment fields - mostly document reports and screenprints, Word, pdf versions etc.
This is all fine, but I don't seem to be able to extract/export them!

Please would someone advise me if this is a copy/cut and paste job, a export job or other...?
Which database view would I need to be in. Where would they end up - folder? Excel spreadsheet? My decision...?!

I don't have many attachments at this time - still early days - but I am keen to refine these processes now whilst this is the case!

Thanks all - hope to hear from you soon.

[June7]

Must use VBA code to extract documents from attachment field. Review http://blogs.office.com/b/microsoft-...cess-2007.aspx

You should know that embedding documents in database chews up Access storage limit, which is 2gb.