I have created a table of employees in a MS Access database. The fields include: ID, Name, and Employment Status. What type of field to I have to add to this table so that an unique photograph of each employer is associated with that employee when a form is created from this table. In other words, I want to be able to access the employee record through a form which also displays the employee's photograph.What do I have to add to a table in MS Access so that an unique picture is associated with each record?
Store the photograph on the hard drive in a seperate folder, store the path to the photograph in your database.