469,964 Members | 1,678 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

how to load images in database access?

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
3 2481
PEB
1,418 Expert 1GB
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
leen85
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
1,418 Expert 1GB
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.

Similar topics

3 posts views Thread by Trevor Fairchild | last post: by
2 posts views Thread by Mehdi | last post: by
5 posts views Thread by chrisse_2 | last post: by
reply views Thread by Frank S. Romano | last post: by
5 posts views Thread by iainfogg | last post: by
9 posts views Thread by Wayne Smith | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.