Access program DB size expand rasant, why?

  • Thread starter Thread starter TNL
  • Start date Start date
T

TNL

Hi,
I use Access 2000 as frontendprogram, backend is also a access 2000 DB.
I my frontend DB, I use "linked tables" for the backend tables.
My program generate or create office menubar and toolbar at startup (in
different languages, ...).

At begin of the development the program size is about 2 MB, but it expands
rasant (quickly?). Now is about 13 MB, during only some records are added in
backend DB (for testing).

the program is also too slowlier on startup.

Why?

I tried to create a new DB and import all components (linked Tables,
forms...), and it is smaller and runs normally.
After 3 days this DB expands again, bigger and runs slowlier.

Can anybody help me?
Thanks
TNL
 
During development, it is normal for the frontend to swell since each
modification results in temporary objects that are not removed until you
compact. Other things can also lead to bloating in the frontend. For a
pretty thorough list of issues please see this article on Tony Toew's
website.

http://www.granite.ab.ca/access/bloatfe.htm
 
Try going to Tools>Database Utilities>Compact & Repair
Database. When your working on your db access doesn't
delete items you've deleted or changed. It keeps them
and adds new stuff/changes to the end. Compacting cleans
all the old stuff out.
 
Back
Top