G
George Moore
Does anyone have code for the compact and repair process
that I can put in my application?
that I can put in my application?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sean
have you tried the
DoCmd.RunCommand acCmdCompactDatabase
DoCmd.RunCommand acCmdCompactDatabase
J
Jeff Clark
doesn't work, says the application needs to be closed first
sigh
sigh
J
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
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
R
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
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
T
Tony Toews
Jeff Clark said: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