473,406 Members | 2,259 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Insert jpg files into Microsoft Access 2000 mdb

Hello everybody,

I have a lot of jpg image files and would like to store them in Microsoft Access 2000 mdb database. I am inserting the images into the database without any problems. But the size of mdb grews unlogically.
Look, if I store any jpg file with 140kb the size of mdb grews 3.7MB, if I insert file with 195kb the mdb file grews 5.5MB, if I insert the file with 10kb size it grews 348KB.
I tried to insert images by two ways. First I tried with opening the file in Corel photopaint and with copy-paste combination insert into database. And the second way just pointing the cursor on the file and carring it into the database.
Is their any other way to insert the images into the mdb with the exect image file size?
Oct 16 '10 #1
1 2973
nico5038
3,080 Expert 2GB
Check: http://www.jamiessoftware.tk/article...ingimages.html and especially the BLOB part.

Nic;o)
Oct 16 '10 #2

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

Similar topics

1
by: Hank Reed | last post by:
For about a year I have been printing pdf files from Access 2000 using the ShellExecute Me.hWnd, "print", FileName, "", 0, SW_SHOWNORMAL We normally print, from 1 to 100 engineering documents in...
0
by: Mathew Hill | last post by:
I am a beginner to the more technical aspects of Microsoft Access (2000) and was wondering if any one can help? I have a field in a table called: ADMIN NUMBER This field should have 4...
6
by: Helmut | last post by:
Hello, I am Helmut, my database has a Frontend of 15.4 MB which cause Acc2K to corruption: Limit is 12.5 MB. Service Pack 3. On three different PCs with 256, 512 and 1.000 MB RAM. All on W2K,...
0
by: alisae | last post by:
Hello. I have a HP6630 Computer, Windows Xp Professional, Office Xp Standard Edition and a standalone version of Microsoft Access 2000 sr1 on a separate cdrom. The problem is every time I want to...
1
by: Paul BJ | last post by:
I am trying to insert into a table in an Access 2000 DB from a VB6 app using ADO 2.7. I would have thought this should have been really easy but I cannot get it working and I cannot see why. It...
4
by: Thelonious Monk | last post by:
Is it possible to convert Microsoft Access 2000 forms and import them into a Visual Basic .NET project? This may be a far-fetched question, but it sure would be nice to do. Thanks!
0
by: vaahini | last post by:
i have upgraded our database from microsoft access 97 to microsoft access 2000. While executing i face problem (Unknown database found) in crystal report 7.0. How to solve this problem. the platform...
2
by: JKChan | last post by:
Hi, I'm an A2 ICT student in second year of college right now and I am working on my database project as my coursework. Its about a dance school with 4 tables Student, Class, Teacher and Enrolment. ...
8
by: diasdaman | last post by:
I know how to import text files, but in this case I need to import a text file line by line on an on-the-fly basis, such that the Access will look at the first two digits of a line, and then import...
0
by: napstar | last post by:
Is it possible to have Access(2002,2003 or 2007) replicate(as publisher) data to SQL Server 2005 or 2008?Code samples would be nice,links would be greatly appreciated.
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
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,...
0
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...

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.