Access program DB size expand rasant, why?

[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

 

[Sandra Daigle]

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

 

[Jim D]

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.