Inserting jpg files in Access table

[SusanW1]

I have a form I want to display staff records with and would like to be able to also insert the staff member's photo into the form. My question is, how to I attach or insert each photo in the table? What type of field to I declare for this "photo" ?

I have separate .jpg files for each staff's picture.

Thanks,
Susan

 

[CJTyo]

It would need to be an OLE Object field to hold a file (of any kind).

C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.

 

[Junior1544]

On a side note, this is going to make your database very large... depending on your situation I would suggest linking to the photo... so only the path and file name are accualy stored in the database... Just a thought...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.