Is it possible to Back Up on Exit of Access 2002 Database ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Intend to distribute package written in Access 2002 with Runtime. Would
like automatic compact and back-up when user exits. Believe compact can be
achieved with "/compact" as a start-up command option, but how do I do the
Back-Up ?
 
The compact on close is an option.
Tools-->Options
Select the General tab and check Compact On Close

The Back up option I doubt you can do, because the database will still be
open.
 
Of course, that only compacts the front-end, not the back-end, which is what
Kevin's looking for.
 
You can set the Compact on Close option for the Back End. It will execute
when the last user connected closes his front end.
 
Thanks to Klatuu and Douglas J Steele for replies.

Your responses only confirm I have a problem ! But thanks anyway.

Consider and let me have your comments on the following alternative.

As database closes another is opened (or second instance of Access is opened).
This second database is a small utility program which will enable compact
and back up of the now closed database.

Any idea how I can do that ?

My Front End does not need to be compacted or backed up since it will not
change and I will provide back up CD. My concern is limited to the BE.

Will the Compact Option on Tools not back up the back end ?

Best regards,

Kevin
 
Have you tested that? As far as I know, Compact On Close on the back-end
database will only work if you explicitly open the back-end, not if you're
connecting to it through a front-end.
 
Honestly, Douglas, I have not. I was taught this by someone about 7 years
ago and being new to Access at the time, took it as truth. In that several
techniques this person taught me then have turned out to be less than the
best way to do things, this gives me pause to consider testing this concept.

I will have to ponder a test scenario that will give me a reliable answer.
 
Back
Top