_be growing

[MArilyn]

I notice when my users are very busy on particular days,
that the backend mdb grows. I compact it automatically,
but I am curious as to why this happens?
Also, I tried reducing the wait time for the initial main
input form to open by only opening a subset of the records
instead of the entire database. But this seems to make the
first problem worse. HELP PLEASE!!!

 

[Lynn Trapp]

Marilyn,
Are you storing any images in the database? There is a known problem with
that in Access.

 

[Guest]

-----Original Message-----
Marilyn,
Are you storing any images in the database? There is a known problem with
that in Access.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.
Yes. One image on the main menu.

 

[Lynn Trapp]

Well, I don't know if the one image would cause the problem, but it's worth
a shot. You should only store the filename of your image and use code to
make the image visible. There is an example in the northwind database on the
Employees form.