_be growing

  • Thread starter Thread starter MArilyn
  • Start date Start date
M

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!!!
 
Marilyn,
Are you storing any images in the database? There is a known problem with
that in Access.
 
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.
 
Back
Top