Database with Pictures

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi Folks - I need some advice .... I have inherited an Access 2000 database
with embedded pictures. Last week, it reached the 2GB limit (It turns out
the table with the pictures is almost 2GB). Our temp fix was to split it
into 2 databases. This fix has worked fine. However, the client really wants
one database, and preferably with the pictures in the database. Any ideas?

Mike
 
Yes, that is one of our options ... but as I mentioned, the client would
like to store the pictures in the database. Are there any techniques that
would minimize the size of a database with pictures?

Mike
 
Why does your Client want to do this? what is his rational? Perhaps your
Clent doesnt understand the procedure, assumes he is losing something?
You might point out how inefficient this is, can lead to problems with db,
is not reccommended for a large db etc.
 
See:
http://www.lebans.com/loadsavejpeg.htm
A97LoadSaveJpeg.zip contains a database demonstrating how to use the
Intel Jpeg library with Access. Jpeg files are stored in their original
compressed state within a Binary OLE avoiding the Ole object "bloat"
issue. Here is the A2K version: A2KLoadSaveJpeg.zip

A standard Image control is used to display the contents of the field
containing the Jpeg file. The Intel DLL is used to load the contents of
the field directly into memory bypassing the need to create a temporary
disk file.

The contents of the Image control, containing any supported source Image
format, can be saved to disk as a Jpeg file.

Very large Jpeg files that could not be loaded into the standard Access
Image control directly can now be loaded through the Intel Jpeg library.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top