Save images in Access Using ADO in VB6

[:: K i r a n ::]

How To Save Image File as OLE Object in Access OLE Object Field using ADO as database access object in VB6

[Shuja Ali]

Welcome to the Forum

Take a look at our FAQ, you will see couple of threads that will help you solve your problem.

http://www.codeguru.com/forum/showth...hreadid=197304

[hensa22]

i hope it's useful

sub SaveImg(Path a string)
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim mystream As New ADODB.Stream
Set mystream = New ADODB.Stream

mystream.Type = adTypeBinary
rs.CursorLocation = adUseClient

rs.ActiveConnection = ConnectionString

rs.Open "SELECT id_TABLE,info,image FROM imagenes where ID_TABLA=condition" 'condition must be value that return 0 recordsets
rs.AddNew
mystream.Open
mystream.LoadFromFile path

rs.fields("id_table")=your_ID
rs.Fields("image") = mystream.Read
rs.Fields("info") = "bmp"
rs.Update

rs.Close
mystream.Close


end sub

and ID_TABLA is primary of table

[:: K i r a n ::]

I am handling a large-scale project entitled as MIS (Marketing information System). I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool.

1) In the project i am required to save customers image to database, and it should be shown in individual customer’s report, which will include that image. I had taken OLE field in the database to save images. I had taken Common dialog box control to select image and display it in OLE control, but i don't know how to save the OLE controls image to database. i am using ADO object to access the database. How could I can save and retrieve the image from database? Is it possible to save images by using other controls like Picture box or image control in the form? I want to save image as bitmap in the database.

2) The size of project is very large then it is useful to store image to database? Will it make it slower to access database?

3) Saving path of image in database will make any difference? If i do so then how can show the images in report (Crystal report 8)?

[amarjitamarNew]

When working images in Database, the type of project you are working on, use small pictures. Because the whole database will be loaded with data and loading big image data will make it very big and you will face problems. Try to store images as small as possible. This will also make you loading and saving time short as byte by byte will be stored into the database and will be retreaved.

The access time of a record depends on the size, struncture of a database and also the processor speed, if you have a pentium III amd have a huge database it is obvious that it will take time to load and save data.

Saving path of images are good practice but it have many disadvantage. Once the folder you store the image get moved you are unable to load the images. Moreover you cannot protect a particular image from loading as it is open. If any one renamed an image but you have a different name in the database you cannot retrieve the same.

Hope i have been able to give your some information.

regards
Amarjit

[:: K i r a n ::]

Thanx amarjitamar,
Your suggestions will help me out! Thx once again