RE: bound object frame: picture

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: NMex Ron (rrrlonghorns_at_hotmail.com)
Date: 02/21/04 

Date: Fri, 20 Feb 2004 19:36:06 -0800

I sent this yesterday -- but it was not posted, so I will try again:
2-19-2004
Bob,
I hope you get an answer to your question.

I have been trying to get an answer on the same basic subject for about two months now.

Warning: If you follow the Northwind sample an link the pictures, your entire database will stop working when you get about 100 pictures 'linked'. The error message is "Database has reached maximum size".
In Access97 this is 1GB, Access 2000 2GB (200 pictures).

I thought 'linking' would keep the photo 'out of the database' However, this is what I have learned:
"...., as well as 'linking' to the original file, a 'Preview' image is stored in the database. Since this image is uncompressed it can be up to 100 times the size of the original image file (or more), hence the problem you are seeing."

I have tried splitting the database, linking tables from additional databases, and finally not linking the photos but only storing the text description of the path to the photo file in the database (as suggested by all the 'experts'). This works okay in 'FORMS', but when trying to view or worse yet print a REPORT, the database locks up and 'times-out' while attempting to format the reports with the pictures.

This is a link to the MS solution (Works with the results I described above):

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

Here are the subjects of the 'threads' I have posted on this forum (I am trying some others as well):
How do I correctly write this expression?
Photo Paths
LoadSaveJpeg

Best of luck - (maybe no photo?)
Ron

Relevant Pages

  • Re: I dont feel confident about my teeth (see the picture)
    ... >Haha, fortunately, I was wearing my sunglasses. ... PS~ I even tried chopping the photo into three sections because of ... >> You are in luck. ... We have some excellent orthodontists on this board. ...
    (sci.med.dentistry)
  • Re: Why Hincapie Will Never Be Considered a Champion
    ... Using that photo as evidence that he's not a champion is ignorant. ... George causes his own bad luck with bad decisions and poor judgment.. ...
    (rec.bicycles.racing)
  • Re: [SLE] Printer Problems
    ... Le Dimanche 20 Nov 2005 20:48, Kai Ponte a écrit: ... I've reinstalled the printer and no luck. ... A good place to start is the log files. ... I currently use an Epson stylus photo r300 and have no problems (although I am ...
    (SuSE)
  • Re: A Medieval Seal
    ... With a bit of luck I will have ... Anychance of posting a photo of the seal? ...
    (rec.heraldry)
  • Re: Highlights
    ... have tried to cover it and remove the highlight with the spot healing ... It might be helpful if you could give us a link to the photo. ... Perhaps a less busy image overall, ... It's a tough one to work on; good luck. ...
    (alt.graphics.photoshop)