Database with Pictures

[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

 

[DL]

Store the pictures outside the db and link to them

 

[Guest]

Try this link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285820

Regards

Peter

 

[Michael]

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

 

[DL]

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.

 

[Tim Ferguson]

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?

I have not tried this personally, although I keep meaning to give it a
whirl. At least it comes from the makers ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;103257


Maybe that will help


Tim F

 

[Stephen Lebans]

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.