By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,457 Members | 1,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,457 IT Pros & Developers. It's quick & easy.

Backing up an entire db

P: n/a

I would like to know if an Access db can be backed up with the push of a
command button. I work with extreamly lazy operators who despite
crashing their db's still refuse to see the value in backing up their
db's. Fools them..but its me that has to undo the boondogal. I would
like to be able to put a buttom on the form which will send the a copy
of the db to another drive, perhaps a USB stick. Any ideas?
*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
One way to get their attention is to hide the backups, so when they
screw up, they burn themselves badly. then you wait a day or so for
the shock to sink in and then give them a backup.

Try
http://www.datastrat.com/Code/KickEmOff.txt

and

http://www.datastrat.com/Download/KickEm.zip

Can't remember, if it includes a scheduler, but you could make the
KickEmOut code to run overnight, so that the database gets closed and
then backed up when they're not using it. Or you can use KickEmOut to
force them all out while you back up the DB...

Nov 13 '05 #2

P: n/a
I like the way you think. And thanks for the link. But if i've got this
right it will inform them that the db is closing in preperation for a
back up, and I like that, but it dosn't bring me closer to an Auto back
up or backing to a different location...Or did I miss something.

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

P: n/a
There is a Sub
SaveMDBObjectsAsText()
in the Module
Save_MDB_Objects_As_Text
in the file
Downloads.mdb
available (compressed->155 kb) at
http://www.ffdba.com/downloads/downloads.zip.
For me, it does what you want, and some other things. It may do what
you want it to do.
There are some lines commented out. You may wish to discover what they
do and uncomment them. You may wish to comment out some of the lines
that are operative. You may wiash to make changes (such as saving to
the USB stick). You are encouraged to do do.

Note: I have run the corresponding code for ADPs a million times with
no problems. But the first time you run it, I suggest you back up your
db in another fashion, FIRST.

It requires Access>=2000.

Nov 13 '05 #4

P: n/a

Thanks, unfortunatly I could not get it to open after unzipping. I
received an error message stating that it was created in a later version
of Access than the one I'm using. I'm using Access 2000.
*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #5

P: n/a
Stewart Graefner wrote:
Thanks, unfortunatly I could not get it to open after unzipping. I
received an error message stating that it was created in a later version
of Access than the one I'm using. I'm using Access 2000.


I modified the zip file to include text copies of all modules.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.