Printable View
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.
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...c/msubdata.htm
HTH
Lenin
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 .