I have a DB up in the Files section, compact2000.zip (another for Access 97), which can be modified to run automatically to compact databases, and you could make it do the compact and then copy the database to another location. Then just put it in a task scheduler to run at some time that no one will be using the databases.
Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of danielbailey77 Sent: Tuesday, October 18, 2005 12:35 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Compact DataBase Is there a way to easily automate (like run at a set time on a daily basis) the compaction and backup of access databases? --- In AccessDevelopers@yahoogroups.com, "Eric Douglas" <[EMAIL PROTECTED]> wrote: > > And in fact, quite the opposite is true: not compacting your databases > periodically can cause problems. > > > ________________________________ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Brown > Sent: Wednesday, August 17, 2005 5:24 PM > To: AccessDevelopers@yahoogroups.com > Subject: Re: [AccessDevelopers] Compact DataBase > > > I have not seen any time where compact database cause any issue. > > Mark Brown > AgileInfoSoftware > http://www.agileinfollc.com > > ----- Original Message ----- > From: Alfredo Mendiola Loyola > <mailto:[EMAIL PROTECTED]> > To: AccessDevelopers@yahoogroups.com > Sent: Wednesday, August 17, 2005 8:17 PM > Subject: [AccessDevelopers] Compact DataBase > > Dear All: > > > Is there any risk for Compact an Access Database? > > Thanks > Alfredo Mendiola Loyola > Lima Perz > > > > > > TERRA NETWORKS PERU S.A. - Servicio de Correo. > > > > > Please zip all files prior to uploading to Files > section. > > > > > SPONSORED LINKS > Microsoft access database > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database&w1=Micros > oft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access& w4 > =Microsoft+access+database+design&w5=Microsoft+access+database+trainin g& > c=5&s=163&.sig=TjCMMZaJBtroyAQ8dznVsQ> Microsoft access > developer > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+developer&w1=Micro > soft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access &w > 4=Microsoft+access+database+design&w5=Microsoft+access+database+traini ng > &c=5&s=163&.sig=oqhFqsmlUZ5Zh6pQgnvTDQ> Microsoft access > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access&w1=Microsoft+acces > s+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Micros of > t+access+database+design&w5=Microsoft+access+database+training&c=5&s=1 63 > &.sig=MMKzpewSlzpK714XaCARAQ> > Microsoft access database design <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database+design&w1 > =Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+ ac > cess&w4=Microsoft+access+database+design&w5=Microsoft+access+database+ tr > aining&c=5&s=163&.sig=ecBsMdKeZw8i4_1kkC6epA> Microsoft access > database training > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+database+training& > w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsof t+ > access&w4=Microsoft+access+database+design&w5=Microsoft+access+databas e+ > training&c=5&s=163&.sig=FHk4Yggbv_zB-TsXvHyeig> > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > * To unsubscribe from this group, send an email > to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe > > > > * Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . > > > ________________________________ > Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
