.jpg files stored in Access

[DrewDog_21]

I am developing an application in which the client will need to store a .jpg picture of each person in the database. I have the files saved as OLE objects in a field called "PHOTO" but I have no idea how permit the client to view or insert pictures.

Can anyone help?

Thanks

Andrew

[mhayenga]

I've previously posted this question myself.... And, of course, it wasn't answered..... So, someone please answer this.... Thanks

------------------
Mitchell Hayenga
[email protected]

[Mongo]

Try using a picturebox control as a data-bound control linked to the OLE object field and allow direct loading/saving by loadpicture and savepicture commands. MSDN has several related articles: Q147727 and Q103115 should help.

[DrewDog_21]

That should work fine just for viewing the fotos, but I need to be able to add and delete them. Right now I am storing the fotos in a separate folder and using a pointer in the database. That works but is very crude. Anyone have any ideas?

Thanks

Andrew

[smalig]

Here's the tip how to save a picture file to the MS Access database
http://vbcode.webhostme.com/en/click.asp?id=71

Try it.

------------------
smalig
[email protected]
http://vbcode.webhostme.com/