How to compact and repair a mdb with VBA code

[Simon]

Dear reader,

How can I use a command in the current mdn to compact and repair the mdb.

In which the source file is the current database.

Thanks for any help.

Kind regards,

Simon

[Jens Schilling]

Hi,

How can I use a command in the current mdn to compact and repair the
mdb.
In which the source file is the current database.

Take a look at this :

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

Regards
Jens

[tombsy]

you cant because it is THE database and it wont let you.

you can however use two alternate approaches.

1.Use a shortcut to open the database with the "/compact" in the
path(easiest method, look it up on the interweb)
2. Get your MDB file to write a BAT file containing the compact command
which you execute from the SHELL command to fire up the BAT file once your
MDB is closed. (tricky stuff)

"Simon" <Sv********@Versatel.nlwrote in message
news:45**********************@news.tele2.nl...

Dear reader,

How can I use a command in the current mdn to compact and repair the mdb.

In which the source file is the current database.

Thanks for any help.

Kind regards,

Simon