How to compact a database without opening it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a dababase that grow rapidely, mainly because of high volume of
transaction, update, add and delete record. So my DB can pass from 15 mg to
150 mg in less than a month (when I open the database and use the repair and
compact utility the DB come back to 15 mg or around it).

I would like to create a script that would be run each 2 week. The main
purpose of this script would be to compacte the DB.

So is it possible to do so ... without openig Access? Can we use jetpack
utility to do so?

Many thanks for your help!

Stephane Pelletier
 
Hi guys,
You could ask Access to compact your Application anytime you close the
application rather than postponing it to every 2 weeks. If it is ok by u to
do it each time you close Access, then follow the these steps, namely;
1 At file menu click on tool
2. Select options
3. Click on General tab and
4. check "Compact on close" option.

I wish u good luck.
(e-mail address removed)
 
<< Jetcomp should do it http://support.microsoft.com/?id=295334>>


Does it work for Access 2000. This is not clear from the article.

i.e. It says at the botom it is for Access 2003 and 2002 yet it says in the
text that the host system must have one of a list of applications installed
for it to work. Access 2000 being one of them.
 
The Compact On Close option is seldom of any use in a properly designed
multiuser application.

This is because the application should have been split into a front end
(containing the queries, forms, reports, macros and modules), linked to a
back end (containing the tables). Each user will have his/her own copy of
the front end, so all that's going to get compacted using the Compact On
Close option is that user's personal copy of the front end, when, in fact,
it's the shared backend on the server that needs to be compacted.
 
Phred Bear said:
<< Jetcomp should do it http://support.microsoft.com/?id=295334>>


Does it work for Access 2000. This is not clear from the article.

i.e. It says at the botom it is for Access 2003 and 2002 yet it says in the
text that the host system must have one of a list of applications installed
for it to work. Access 2000 being one of them.
Click to expand...

Phred Bear.

On the webpage noted, there is a list of supported versions. Fifth
from the top is Access 2000.



Sincerely,

Chris O.
 
Back
Top