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
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