Hangups

  • Thread starter Thread starter Louisa
  • Start date Start date
L

Louisa

We have a large database in Access. It hangs up as we
page through the forms. We have embedded pictures into
the database. The hangups always occur at the same
positions (#63, #138, etc.). What can we do to eliminate
the hangups? We have 2800 entries in the database.
 
-----Original Message-----
2800 records is a very very small database. Lose the
pictures.
Click to expand...
the pictures are a very important part of the database.
We cannot lose the pictures. Is there any format in which
they should be saved? We have embedded all of the
pictures, and they are not viewable in table view. We
are working with 1 GIG of RAM. How can we improve the
performance?
Louisa
 
This is a database of US military shoulder patches and
the pictures are a very important part of the database.
We cannot lose the pictures. Is there any format in which
they should be saved? We have embedded all of the
pictures, and they are not viewable in table view. We
are working with 1 GIG of RAM. How can we improve the
performance?
Louisa
Click to expand...

See some of the suggestions and links at

http://www.granite.ab.ca/access/imagehandling.htm

You can store the image files externally, or in BLOB fields if you
don't tell Access what they are! If Access gets wind that you're
storing a .jpg file, it stores the .jpg file... AND a .bmp file... AND
a good deal of overhead, for every image ("to make thumbnails come up
faster"). You need to trick it into treating the images as meaningless
binary data; the suggestions at Tony's site will steer you how to do
so.
 
LOSE THE PICTURES?! Thats your answer? Well Hell why not lose Access if
your going to do that!
That is NOT the answer MS or any other company wants techs to give. VERY BAD
answer.....
 
put the pictures in a link - (http:// or file link) or in
a seperate table. Dont display it till you need to. (I
guess your going to say you need to page through every
picture - why!!)

Hope this helps
 
Back
Top