Backing up Your Database by using Access 2003

vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. Enhances the Toolshed More..

DryToast New
Backup and query your BaseCamp® projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new Expression Web
vb123.com.au

Backing up Your Database by using Access 2003
This is a sample from the Microsoft Access Protection book by Garry Robinson

With the arrival of Access 2003, a new menu command handles the naming conventions for backing up a database, and it's an option well worth considering for any DBA who is interested in a simple, well-organized backup process for their Access format databases. The system works by asking you for the folder of your backup database (as shown in Figure 5-19).

Figure 5-19: The Backup menu command.

It then compacts the current database to that folder. The file name suggested for the backup results from concatenating the name of the current database with a date string. If you back up your database more than once a day, the name of the backup database will also receive a numerical suffix to differentiate between each of the backups for the day (as shown in Figure 5-20).

Figure 5-20: Access 2003 backup wizard in action.

Naturally, there are some complications with this process, such as:

You need to store the backups in a safe place if you are trying to protect the information in the database.

You will need to make sure that everyone has logged off the database before running the backup.

You need to make sure that you back up both the front-end and back-end databases.

You will need to clean up all the old backup databases by using Windows Explorer or some other system that lists files in the directory.

They are not compressed

Find Out More

These samples are discussed at length in Chapter 5 of Garry's Book on Access Protection and Security Read More
You should also try out the simple backup process that comes with the Access Workbench

Other Pages At VB123.com That May Be Of Interest

Duplicate Data Entry For Access
Citrix / Remote Desktop – for an Access-developer

Click on the following button to jump to the next page in the protection samples loop.