Help with Access database

[paul]

Hi I want to create a database in msAccess and store information as well as pictures for each record.I have no Idea where to start.
1) How do I store the picture? (.jpeg file)
2) How do I pull this information up in my prgram? (display the picture and record information)



Any suggestions are welcome.

[lenin]

Paul,
this is a very broad question. I think if you search for ole object in Access you will get information about storing images.

As for retrieving this information from a database, this can be done in a variety of methods, depending on your time, design, preferences etc.

Essentially it involves attaching to your database ( perhaps using a DSN ), and submitting SQL to the database engine for retrieval, and associating your client controls ( text boxes, labels etc ) to particular fields from the recordset. There is a plethora of examples all over the web, and I have seen numerous examples such as

http://visualbasic.about.com/compute/visualbasic/msubdata.htm

HTH

Lenin

[paul]

I have created the database with the picture but when I create a program to view the database it does not show the picture. It shows an icon of the paint program the picture was created in. What am I doing wrong?
I am using an OLE object .