Samples of how to backup and recover your Access database

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

Samples of how to backup and recover your Access database

The samples shown on this page are for owners of The Toolshed. ... Download Sample

With these samples you will learn how to
Object Name Access Version	Topic	Object Type
frmIsDBopenDAO	Find out if anyone is using a database using DAO library. Good to see if you can open a database in exclusive mode.	Form
frmIsDBopenDAO	Find out if anyone is using a database using ADO library.	Form
frmAutoShutDown	Simple form that will shutdown the database every day at a certain time for administration	Form
frmCompactDatabase	Compacting database to another file - used for backup	Report
frmCompactEasy	Very simple form that provides a one button method to compact the current database	Report
frmGR8_unloadAll	Unload all tables in a database to comma delimited text files. Useful for additional backup of databases.	Form
frmUnloadADOxml	Unload all tables in an Access 2000+ database to XML format.	Form
frmBackupAllObjects	Demonstrate how to backup all queries, forms, reports, macro and modules to text files.	Form
basGR8_exportObjects	Module to backup all all queries, forms, reports, macro and modules to text files.	Module
basGR8_Startup	Includes openform and openreport functions, userlogging, find current path of database and change window headers.	Module

Sample Databases

Click here for the Access 2002/2003 sample database file
Click here for the Access 2000 sample database file

Else Click Here To Purchase if you don't own the Toolshed

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
Access 2000/2002/2003 Export To Text Bug/Safety Measure
Take the SQL Taste Test in Access ADO
The UserForm - How to setup a difficult to decode password entry form

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