jpeg

  • Thread starter Thread starter clinic
  • Start date Start date
C

clinic

I have created a form with mostly text so far and would
like to include a jpeg per page. Twelve records into
this project I can tell that the database is getting slow
and the size is getting way larger than the size of the
additional jpegs. I have 500 records in my database and
at this pace I see my system crashing and burning. Is
there a better way to link jpegs into the system as
opposed to embedding? I have research this and find the
solutions to be somewhat advanced. Is there an easy way
to link jpegs to a form?
 
I use a hyperlink type field and store things like
pictures and documents in a separate folder. The text
content of the field in each record can be anything you
want (descriptive is better), but the hyperlink underneath
points to the file in the external folder.
Note that when the hyperlink is invoked, the target will
open in a window with the Web toolbar showing. Use those
arrows to get back smoothly to the data base. You can
close the target window without losing the data base, but
you have to go to the task bar to get back into it.

Another idea, and one that I use a LOT - if you want to
link to more than one item using one field, create a Word
document that contains a list of the items (I call it
an "index" document). The Access record's hyperlink field
points to the Word document (one item), but each item in
the Word doc list is hyperlinked to the item listed. This
works great for field reports, where the reporting
individual may bring home letters, slide shows, spread
sheets, contact lists, etc.
A little extra housekeeping is required, but for a big
data base it may be worth it. You also have to remember
that everything hinges on path names - if anyone messes
with those (server names in particular), the hyperlinks
are busted.

Hope this helps.
 
clinic said:
I have created a form with mostly text so far and would
like to include a jpeg per page. Twelve records into
this project I can tell that the database is getting slow
and the size is getting way larger than the size of the
additional jpegs. I have 500 records in my database and
at this pace I see my system crashing and burning. Is
there a better way to link jpegs into the system as
opposed to embedding? I have research this and find the
solutions to be somewhat advanced. Is there an easy way
to link jpegs to a form?
Click to expand...

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

While you are at Stephen's website check out his examples, controls, and
classes for displaying images -- they may be better than the Image control.

Larry Linson
Microsoft Access MVP
 
I had a way of doing this that worked really well by linking to sites.
Unfortunately I lost the set up and am trying to find it again. did you
have any luck?

John
 
Back
Top