Help!!! Access keep closing program

  • Thread starter Thread starter hin87_at_yahoo.com
  • Start date Start date
H

hin87_at_yahoo.com

Hi

In Access 2002, the size of my front-end database increases from 5MB
to 56MB over the course of the day. I could see the database size
increases each time I open up reports in Access. My reports use
regular objects like combos, texts and labels. The report does have
linked picture object for my logo (size at 185KB). I'm using a saved
query to grab the data for the reports. It seem like Access do not
want to release the memory after I closed Forms/Reports.

Did anybody notice this big bug in Access? How can I reduce the size
of the files over time, besides doing a Compact database?

Another problem I keep encountering is that my Access keeps crashing.
I would get a message about "Access has just recover from a serious
crash, do you want to send the log file to Microsoft" or sometime no
error message, it would just exit out of MS Access.

I have tried:

307841 OFFXP: How to Obtain the Latest Office XP Service Pack
http://support.microsoft.com/?id=307841829558

Information About Jet 4.0 Service Pack 8
http://support.microsoft.com/?id=829558

Thanks,
H
 
There is a Compact-On-Close option in Tools / Options ... that can
automatically compact the database when you close the database.
 
Yes, I tried that already. But my concern is that why would the
database size get so large just from opening and closing
reports/forms.

Also do you know Access keep reporting errors and closing my program?
 
I think Access uses the file to hold temporary data and graphics for the
Reports. IIRC, some previous posts indicate that all graphics are handled
like bitmaps so they can be fairly big.

Do you have the shut-down problems with only one particular database or all
databases?
 
Only in this database, I think. I'm only using Access for this
particular project.
 
Back
Top