I'm a retired client/server relational database designer with some OO background but new to scripting and XML. I need to create a single user executive database application to catalog, format and print photos and data.
We have thousands of high quality photos, a fast Win XP workstation, Adobe CS3 and Office Pro 2007.
The use cases will involve scripting PhotoShop, Bridge, and Acrobat as well as storing and retrieving data from MS Access.
My question concerns how best to structure the app. What framework if any I should use to tie the app together.
What app would be best for the primary UI? I know how to create an app within MS Access, but it would be clunky and I would rather build the Client portion in Dreamweaver and only use Access for the back end.
What would be a good reference work for me to follow?
YOur opinions and experience would be much appreciated.