compact & repair

  • Thread starter Thread starter justin vn
  • Start date Start date
J

justin vn

Is it possible to create a button on a form to 'compact
and repair'?

I have a database that does not make use of the file menu
therefore the only way right now to Compact and Repair is
to open the database with shift key and then proceed with
Compact and Repair from Tools, Database Utilities, and
Compact an Repair...

justin
 
Justin,

In theory it can be done, though not recommended.
In my experience the best way to tackle this is to have the .mdb
auto-compact on close (Tools > Options, tab General, tick Cmpact on Close).
Would this work for you?

HTH,
Nikos
 
I just tested your suggestion. It took about 2 minutes
until Access finally closed. I would not want the users
to go through this process and it may cause conflict if a
user wants to open the database while another user is
compacting it.

I think I will just have the administrator do this
manually once a month.

Thanks anyways,

justin
 
If you have multiple users on your database, then you
should split it into a front and back end. The back end
would have the tables and would therefore be the only
thing that needs to be compacted.

As Nikos stated then, put the compact on close only on the
backend and close it (you can automate that) once a month
or so (when there are no users on it (no .ldb file for
your db) of course). This should solve your problems
without bothering the users.

HTH
 
Back
Top