compact & repair

[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

 

[Nikos Yannacopoulos]

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

 

[Guest]

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

 

[Ernie]

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