DBEngine.CompactDatabase vs Compact on Close

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: dch3 <dch3@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 8 Aug 2008 10:29:01 -0700

If I implement DBEngine.CompactDatabase when my database closes (as opposed
to the Compact on Close option), are there any caveates that I should be
aware of?

I want to give my users a message that the database is shutting down as
opposed to the Access Application Window just sitting there until the DB is
compacted.

I'm also fully aware that I'll have to build the code into an Exit routine
and then force the user's to Exit via the routine - I'm in the process of
implementing custom Menu Bars.
.

Follow-Ups:
- Re: DBEngine.CompactDatabase vs Compact on Close
  - From: Douglas J. Steele

Prev by Date: Cannot update DAO Recordset
Next by Date: RE: Event when Access table is accessed through ODBC ?
Previous by thread: Cannot update DAO Recordset
Next by thread: Re: DBEngine.CompactDatabase vs Compact on Close
Index(es):
- Date
- Thread

Relevant Pages

Re: DBEngine.CompactDatabase vs Compact on Close
... Compact On Close only works on the "active" database (the front-end). ... I'm also fully aware that I'll have to build the code into an Exit routine ...
(microsoft.public.access.modulesdaovba)
RE: Compacting MDB help
... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
(microsoft.public.access.modulesdaovba)
RE: Compacting MDB help
... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
(microsoft.public.access.modulesdaovba)
RE: Compacting MDB help
... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
(microsoft.public.access.modulesdaovba)
Re: Access crashes when opening form
... Allen Browne - Microsoft MVP. ... You were correct in suspecting SP3. ... I've also had a problem with "compact on close" not working (it ... database works correctly there. ...
(microsoft.public.access.forms)