Compacting a database

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

All of our databases compact on close. One of our larger
projects takes longer to go through the compact process
than we would like.

It seems to stall just before half way, then picks up
speed to finish. Ideally, having databases close
without "appearing" to compact is best but not sure how
or if this can be done.

Is there any way this process can be sped up, or is there
another way to make it happen, or is there something in
our database that is causing the stall.

Any help appreciated. Thanks

Connie
 
Hi Thanks for the reply. Actually we really need it to
compact on close and have set it up that way. What we
would like is to speed up the compact process or to
discover why it takes so long to compact and why it
stalls in the middle of the compact.

Again thanks
Connie

-----Original Message-----
Hi Connie,

There is an option where you en- or disable the compact
Click to expand...
on close function. This is stored in each database if it
should compact or not on close. Therefore open your db
and go to : Tools - Options - General and there it is :
Compact on Close
Depending on the size of your db and what you are doing
Click to expand...
within (running a lot of huge queries, reports, imports,
etc.) you should manually run compact & repair from time
to time.
 
Are your applications split into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing only the tables)? If
so, then there's no need to compact on close: just have a scheduled process
that compacts the back-end on a regular basis.
 
Back
Top