Access forms refresh very slow

[Nicolae Fieraru]

Hi All,

I have a database with 300 records. There are some OLE images embedded into
the database and the size of it is 45MB

The database is split in front end and back end.
I have a few questions.

1. I would like to know what is the size of the OLE objects that I have in
the database. At this moment I am not sure if the user introduced resized
images or very large images in the database. I believe that the images are
BMP with a size of 200x150 pixels and the average size is around 117KB.
Since 300 x 117KB = 35MB, I expect there are the right images included
(small ones).
2.When I open a form based on a query in continuous mode and I list about 3
images, it takes about 1...7 seconds for the form to appear or to refresh
the information (I use a 1.7GHz computer with 512MB RAM and 64MB video
card). About the same time it takes to display records in a single view form
when the query contains all the records.
I wonder if this is "normal", because for me it feels awfuly slow. If I open
the query, it opens it immediately - it is slow when it displays the
continuous form with the images.
3. Is there anything I can do do make the database faster?

I had to choose OLE for the images because I need to display different
images based on queries in my reports

Regards,
Nicolae

 

[[MVP] S.Clark]

1. Copy & Paste the image to Paint. Save it. Check the filesize??
2. How about hiding the images until the user clicks a button to view.
3. Yeah, remove the images from the database. Store a text string of the
path and filename, instead.