Dtabase size increase continuosly

  • Thread starter Thread starter Duniel
  • Start date Start date
D

Duniel

My database size increase more and more with each
excecution without adding new register on my tables.
after execute compact and repair command from the tools
mennu the size is 1.5 MB after each excecution the size is
twice at the begining.
after 10 times execution the size is about 75 MB.

What happen? and What can I do?
thanks
 
Typically the size will bloat most with design changes. Are you modifying
or creating forms, queries, or reports? If so, that will cause this
problem. Once you finish building on your database you will see less
bloating.

You could set the database up to "compact on close" in the Options.

Rick B
 
My database size increase more and more with each
excecution without adding new register on my tables.
after execute compact and repair command from the tools
mennu the size is 1.5 MB after each excecution the size is
twice at the begining.
after 10 times execution the size is about 75 MB.

What happen? and What can I do?
thanks
Click to expand...

You may need to create a new, empty database and use File... Get
External Data... Import to import everything from the existing
database. Even compaction won't get rid of all types of bloat.

Perhaps you could explain what you mean by "execution" in this context
- you don't "execute" a database, it's a data repository and user
interface to that data, not an executable program!

John W. Vinson[MVP]
 
Back
Top