Access compact and repair code

[George Moore]

Does anyone have code for the compact and repair process
that I can put in my application?

 

[Sean]

have you tried the

DoCmd.RunCommand acCmdCompactDatabase

 

[Jeff Clark]

doesn't work, says the application needs to be closed first
sigh

 

[Joan Wild]

You cannot compact the current database in code. You can

1. if you have a custom toolbar, include a button for compacting the
database.

2. use a tool such as TSISoon to compact the current database - it's
available at
http://trigeminal.com/lang/1033/utility.asp?ItemID=8#8

 

[Richardson]

I am not sure if this will answer you problem or not, but it is the answer I
came up with for the same problem in my databases.
Under Tools - Options, there is an option to "Compact on close." If you
check this box, the database will be compacted when it is closed. This
seems to work in a shared environment as well. The catch is that you have
to have the right version of Access for the option to appear.

Lori

 

[Tony Toews]

doesn't work, says the application needs to be closed first
sigh

If you are trying to compact a backend from your frontend then you
must close all bound forms and reports as well as any recordsets you
may have open.

You can verify this during testing by looking for the presence of the
ldb file in the backends folder.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm