Compact / Repair from within the database?

  • Thread starter Thread starter David Walker
  • Start date Start date
D

David Walker

I've been putting together an Access application for the past couple of
weeks, with the intention that i'll be able to leave it once its done and
for others to be able to use it in the best possible way with the least
possible effort. I've already got in some stuff to fix something for
example if something fails halfway through it'll put everything back to how
it needs to be to work again.
The only thing I can't get to work is the compact function. I just want to
be able to run it from a menu in the database itself (ie a 'maintenance'
form), and for it to compact itself, and bring me back into the database.
Reading the help file, it can be done, but it seemingly wants me to copy it
to a different file, then delete the original and rename it - all while the
database is closed, which I don't suppose Access can keep control of if its
not open.
Any ideas on how to best achieve that? I really don't want to leave
instructions somewhere saying "go to this menu, then that menu, then click
this, then do that......" - just want to make it all automatic, invisible,
simple.

Cheers

David
 
What about if you just have it compact on close?
Tools - Options - General Tab
Click to expand...

Ahh - perfect! Didn't know about that... as long as it exists in Access 97
too
Thanks

David
 
Hi David,

As I mentioned before I have not used the utility, but I would *think* it should work for Access
2002 and 2003. I would give it a try with Access 2002 on a BACK-UP copy of your database first. Make
lots of back-ups actually. If you're still having problems you may want to start a new thread with
TSI-SOON in the subject line. Michael may jump in himself and give some guidance.
 
Sadly no David, the "Compact On Close" option only became available from Access 2000 onwards. You
will not be able to use that functionality in Access 97.
 
Yep discovered that today... oh well!
I'll have to remember to stick the addin on a disk before monday (forgot
last night)

David
 
Back
Top