Backupping a DB !!!!

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi,

I know backupping sounds funny...but that's what I want to
do by way of clicking a 'Close' button on a form to close
down a DB. Once clicked it will pop up a message box
asking "Do you want to backup the DB before closing?".
Typical vbYes, vbNo which if yes, then proceed to make a
backup before closing.

The way I've been doing it is to go to my Folder and use
COPY, and I'd like to automate it if possible. Can you
please help?

Many thanks.

aj
 
You can not take a working backup copy of the currently-executing database.
However, if you split your database into a so-called "front end/back end"
structure, the front end (which contains the forms etc.) >can< take a
working backup copy of the back end (which contains all the tables). Google
for front end/back end or FE/BE or similar for more information.

HTH,
TC
 
Hi

We have just posted a complete free chapter from my new
book on the vagaries of backing up an Access database (50
pages). Follow the free chapter download link at

http://www.vb123.com/map/

Garry Robinson
 
Back
Top