AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question I have been asked to design a database for tracking images.
Basically, I need to house all image names and locations. Then I need to have a list of all the contents of the images. These contents will change, and not all the images will have the same content at the same time until they are updated.
I need to be able to query what a particular image needs, and what the image has on it (separate queries)
If something new comes out, I should be able to type it in one place and update all the images.
My database skills aren't terrible, but I am at a total loss as to how to lay this out. Any suggestions would be greatly appreciated.
David S
Answer I'm not sure I follow what you need. An image is a visual representation of something. An image doesn't usually change. An image might be replaced with a different image.
I can see an app where you store info about an image. Part of this info is a list of attributes for an image. In such a case I would have a table with info about each image and an attributes table with fields of ImageID and Attribute.
Hope this helps,
Scott<>
Please don't forget to provide feedback for this response (either by rating or followup). It helps me help people better if I know how my advice worked.
