473,656 Members | 2,921 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to load images in database access?

4 New Member
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
Oct 2 '06 #1
3 2701
PEB
1,418 Recognized Expert Top Contributor
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 New Member
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 Recognized Expert Top Contributor
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\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 :)
Oct 7 '06 #4

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

Similar topics

3
13871
by: Trevor Fairchild | last post by:
I am making a program that categorizes pictures. The picture paths are stored in an Access Database, vb6 connects using adodc controls. This program works specifically with .jpg files. It will be used by people categorizing thousands of images. The problem I have is that both the picture control, and the image control seem unable to open certain jpg images for an unknown reason. The error message simply states "Invalid Picture". I can...
2
2104
by: Mehdi | last post by:
Hi, I have 3 small images on my page. I also have a large image which is displayed when any of the 3 small images is clicked. I do this to display a large version of each image. On page load the large image displays the img1 by default. But sometimes (in IE and NS) when I click on small images, the large image is empty and if I refresh the page it will display it. Here is my code:
5
4792
by: chrisse_2 | last post by:
Hi, All the records in my database will contain at least one picture. At the moment all the images are part of the database as ole objects although the database is way to big and there is only 12 records in it. I have been reading about linking images into the database and i would like to use the method linking via code this way the database will be as small as possible.
0
1861
by: Frank S. Romano | last post by:
Hello, Does anyone know how to bind the image property of a picture control to an Access 2000 database OLE object column that contains a MS Photo Editor 3.0 photo? When I try binding the picture control image with the advanced binding panel, my dataset shows the table with the column but it will not set. I read thru the MS Knowledge Base and the closest solution I could find was article 317701. The example code reads an image "from...
5
1699
by: iainfogg | last post by:
I had an ASP.NET 2.0 site which works fine on my PC. I have just copied it to a server, and set it up to run in a virtual folder. The web pages work fine, but the graphics won't load - if I try to open a gif from one of the folders, I get the following message. Why would an ASPX file load, but a GIF file won't? I have tried messing with security on the files, and have even given 'Everyone' access to read and execute, but still no joy. ...
9
3824
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web site for a small club I belong to and one of the features I would like to include is the ability to allow users to upload image files. unfortunately the servers web root www folder only allows READ and EXECUTE permissions, which makes it...
0
2065
by: leen85 | last post by:
helo everybody...i'm lina...i need your help...i have a problem in VB and 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 using VBA coding...but the problem is..i want the images be arrange following the...
0
2748
by: Skiran | last post by:
Hi to everybody, I am handling a large-scale project of 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’s customers report also. I had taken OLE field in the database to save the images. I had taken Common dialog box control to select image and
3
1737
by: anthony | last post by:
I am going to have to start holding jpg files (about 6,000 - 10,000 a year) in our school database. Mainly, they will end up being printed as part of the children's profiles ie via a report. I understand that Access 2007 can hold images without the associated bloat created by previous versions. However, I am reasonably used to Access 2003 and would only want to upgrade if there were significant advantages in the way Access 2007 handles...
0
8297
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8816
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8717
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7311
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6162
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5629
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1600
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.