Excess space allocation

M

Michael

One of our Access databases grows very quickly in size.
In just 1 week it will grow from 50Meg to 100Meg yet after
we run the utility to compact it the size shrinks back
down to just a bit more than it was last week. Is there
something that we can look at (i.e. default block size for
each table extent) in Access 2000? If not does anyone
have any suggestions on how we can address this issue
(other than upgrading to SQL Server). We really don't
want to run the compact utility each week.

Any help would be appreciated!!
 
J

John Vinson

We really don't
want to run the compact utility each week.
Click to expand...

Well, some folks don't like to change the oil in their car every 5000
miles either... but both are necessary for reliable performance!

In A2000 you can set the database to Compact On Close; or you can set
up Windows Scheduler to compact the database weekly, sometime when
everyone's going to be logged off.

See Tony Toews' website http://www.granite.ab.ca/accsmstr.htm for some
suggestions about performance and bloat.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grow/Shrink Text gradually from slide to slide 0
File Size 1
Invalid Argument - Append Query 1
Inflated Database size but because of 2007 1
Need help modifying code 0
Alternative to Task calendar set up and percent allocation issue 0
Alternative for task calendar set up and proper percent allocation 0
"Not enough space on temporary disk" for very large table 3

Top