By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,460 Members | 1,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,460 IT Pros & Developers. It's quick & easy.

how to load images in database access?

P: 4
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...each 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.com/d/1024649/Copy_of_PortPass.zip.html

plz help me..

Regards,
lina
Oct 2 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
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
Oct 2 '06 #2

P: 4
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
Oct 3 '06 #3

PEB
Expert 100+
P: 1,418
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...

Expand|Select|Wrap|Line Numbers
  1.  
  2.     OLE1.Class = "Excel.Sheet"    ' Set class name.
  3.     ' Specify type of object.
  4.     OLE1.OLETypeAllowed = acOLELinked
  5.     ' Specify source file.
  6.     OLE1.SourceDoc = "C:\Excel\Oletext.xls"
  7.     ' Specify data to create link to.
  8.     OLE1.SourceItem = "R1C1:R5C5"
  9.     ' Create linked object.
  10.     OLE1.Action = acOLECreateLink
  11.     ' Adjust control size.
  12.     OLE1.SizeMode = acOLESizeZoom
  13.  
  14.  
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\Oletext.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 :)
Oct 7 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.