How Do I Backup my Database Help Please

A

Alan F

Is it possible to put a command button on a form to backup the current
database or is there a better way. I have a small no split database that I
am giving to a friend who is not the best in the world with computers so
automated backup method would be better.

Many thanks in advance
 
D

Douglas J. Steele

Split it, even if only one user is going to be using it at a time.

Create a hidden form that you open when the application opens. In the Unload
event of that hidden form, put code to use the built-in VBA FileCopy
statement to make your backup of your back-end. (no need to back up the
front-end, since it doesn't change)

If you want to get even more sophisticated, rather than using FileCopy to
make a backup copy, have your code rename the existing back-end, then
compact the renamed back-end to the proper file name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New computer, how do i move outlook 365 ENTIRELY? 0
Save copy on Open, keeping old backup copies 5
Backup of back-end db 4
Backup database 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Backups 4
How do I ensure my BCM information get transferred 2
Making Backups 1

Top