I need a way to read and write EXIF and IPTC metadata to/from image files (CRW, CR2, NEF, TIF, JPG, PSD, DNG, XMP) using Microsoft Access 97 VBA and queries.
The interface I need must be able to read all of the IPTC fields written by Photoshop CS2. This includes all IPTC IIM legacy fields and all IPTC core fields.
This interface must also read all IPTC metadata that is written by: Adobe Bridge, BreezeBrowser Pro, Image Info Toolkit, iView Media Pro 3, Photo Mechanic, Photoshop CS2, and Picasa.
This interface must also read all EXIF metadata created/embedded by today's common digital cameras including these cameras: Canon: s45, 300D, 350D, 400D, 20D, 5D, 1Ds Mark II; Nikon: Coolpix 3200, D70, D80, D100, D200; Sony: A100.
This interface must also read all EXIF and IPTC metadata in the THM sidecar files of the Canon 300D.
This interface must also be able to read all EXIF and IPTC metadata in XMP sidecar files.
This interface must be able to write all IPTC IIM legacy fields and all IPTC core fields to these file formats: CRW, CR2, NEF, TIF, JPG, PSD, DNG, XMP sidecar; and must include multi-layer and multi-channel TIF files.
This interface must be able to correctly read and write standard American English non-alphabet characters including: © (copyright symbol); " (double-quote); ' (single-quote); ! (exclamation point); ? (question mark). It must read these correctly as entered from Photoshop CS2, and must write them so that they display correctly in: Photoshop CS2, Adobe Bridge, BreezeBrowser Pro, iView Media Pro 3, Photo Mechanic, and Picasa.
It must allow for various keyword separators including: comma, semicolon, linefeed, carriage-return, carriage-return-linefeed, linefeed-carriage-return.
It must write the keywords in industry-standard fashion, with duplicate entries removed, and sorted.
I am looking for a programmer with whom I can have an ongoing working relationship. I will have an ongoing need for various utilities and capabilities to integrate with my custom MSAccess database. I will also need help, from time-to-time, with explanations, as I am only reasonably computer literate.