Compact And Repair

[FP1]

Is there a way to compact and repair your database from a form and have
Access reopen it's self?
Thanks
DS

I think application.CompactRepair will do it.

 

[Dirk Goldgar]

In

Is there a way to compact and repair your database from a form and
have Access reopen it's self?

Depends on your Access version. In Access 2000 and later, it's pretty
simple; in Access 97 and before, you need a helper application. See
this link, and the links it contains:

http://www.mvps.org/access/general/gen0013.htm

 

[DS]

Is there a way to compact and repair your database from a form and have
Access reopen it's self?
Thanks
DS

 

[Dirk Goldgar]

In

I think application.CompactRepair will do it.

No, I'm afraid not. As the help entry for that method notes:

<quote>
The source file must not be the current database or be open by any other
user, since calling this method will open the file exclusively.
</quote>

Also, that method always compacts the source file into another file.
The "Compact and Repair" menu item takes care of closing the current
database, compacting it into an output file, deleting the original file,
and renaming the output file to the original name. At least, I think it
does it that way, rather than copying the compacted output file over the
original and then deleting it.

 

[DS]

In


Depends on your Access version. In Access 2000 and later, it's pretty
simple; in Access 97 and before, you need a helper application. See
this link, and the links it contains:

http://www.mvps.org/access/general/gen0013.htm

Thanks Dirk,
It is Access with OfficeXP 2002, So what is the method?
DS

 

[Dirk Goldgar]

In

It is Access with OfficeXP 2002, So what is the method?

This one:

http://www.mvps.org/access/general/gen0041.htm

 

[DS]

In


This one:

http://www.mvps.org/access/general/gen0041.htm

Thanks....I will give it a try.
DS