By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

How to compact and repair a mdb with VBA code

P: n/a
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
Nov 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 24 '06 #2

P: n/a
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


Dec 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.