Microsoft Access Equipment Inventory + Images

We use a Microsoft Access database to track equipment. The database allows us to enter basic info about where the equipment is located, model, serial, etc. We want to be able to attached a picture to our database of the equipment. In the access database on the entry form - where we enter the description, barcode, serial, model, etc. - I want a small image preview window (200 x 200 pixels or so) that can show a live picture from a digital camera. The digital camera would be attached to the PC and when the user wants to photograph an item, they do so by pointing the camera at the item so the item shows up in the preview window in MS access, and then by clicking a button on the access form that captures the image. I would prefer the images be saved as jpgs in a common directory and given a unique file name - that file name would be linked to the access database. Coder can advise me as to what type of camera I need to buy. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform windows 2000/xp pro, ms access 2002