how to load images in database access?

[leen85]

helo everybody...i'm lina...i need your help...i have a problem in Access...i have 38000 images for my company employee which size about 5GB to stored in database...as we know we cant stored too many images bcoz it cause bloating in access..so,i want to stored the path of the images only in database...i have stored the path and the images can be displayed...but the problem is..i want the images be arrange following the number for the employee in table Cardholder...ea ch of the images has their own number following the number of the employee such as for employee No. 2...the images will be A2.bmp...do u understand what i mean?this is the project that i have done...can u have a look on it??download it from this link...http://d.turboupload.c om/d/1024649/Copy_of_PortPas s.zip.html

plz help me..

Regards,
lina

[PEB]

Hi lina,

So You want to store your images out of your database and when you open a respective cardfile for employee to have his image in the report do you?

In fact it is possible for a small number of cardfiles opened in the same time coz the procedure of loading of the image takes at least 10 seconds per image!

Do you think that the method that I'll offer you is ok?

Best regards
:)

Vladimir

[leen85]

helo Vladimir....
yeah...i think the method that you offer me is ok...can u explain to me briefly about it?


Regards,
lina

Hi lina,

So You want to store your images out of your database and when you open a respective cardfile for employee to have his image in the report do you?

In fact it is possible for a small number of cardfiles opened in the same time coz the procedure of loading of the image takes at least 10 seconds per image!

Do you think that the method that I'll offer you is ok?

Best regards
:)

Vladimir

[PEB]

Hi lina,

In fact if this is a form that is like a card holder and has an OLE control in which you want to vizualize the fotograph of your employee... You can set this OLE object as Unbound Control Source property = Empty

And you need a little code to visualize each image from your folder with images...

    OLE1.Class = "Excel.Sheet"    ' Set class name.
    ' Specify type of object.
    OLE1.OLETypeAllowed = acOLELinked
    ' Specify source file.
    OLE1.SourceDoc = "C:\Excel\Oletext.xls"
    ' Specify data to create link to.
    OLE1.SourceItem = "R1C1:R5C5"
    ' Create linked object.
    OLE1.Action = acOLECreateLink
    ' Adjust control size.
    OLE1.SizeMode = acOLESizeZoom

STH LIKE THIS CODE YOU CAN PLACE ON CURRENT EVENT FOR YOUR FORM

Change OLE1 with the name of your Unbound OLE Object!
"C:\Excel\Olete xt.xls" with the path of your respective file
OLE1.SourceItem = ""

For the class section you need to consult the access basic help
Maybe like:
OLE1.Class = "Bitmap" ' Set class name.

Hope that helps :)