Add staff photo

[Alhousani]

Hi everybody,
Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo will be detected from scanner and saved directly in the field instead of doing it manually.

Thanks and regards

 

[RuralGuy]

I am afraid you will be disappointed in Access' ability to store pictures. It is pretty inefficient and bloats the db badly. I think I read the ac2007 has made some changes in this area and it is quite a bit better. Others may want to jump in here with their opinions as well. Here's a link to MVP Larry Linson's site where he has prepared several approaches to this issue. It might give you some ideas on a different approach.