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
Your Access 2002/2003 sample database file is called "grMap2002.zip"
and your Access 2000 sample database file is called "grMap2000.zip"
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
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
Click on the following button
to jump to the next page in the protection samples loop.
Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
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
Access 2003 Security
|
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. |
|
| 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 |
These samples are discussed at
length in Chapter 5 of Garry's Book on Access
Protection and Security
Read More
Click on the following button
Your Access 2002/2003 sample database file is called "grMap2002.zip"
and your Access 2000 sample database file is called "grMap2000.zip"
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
Find Out More
You should also try out the simple backup process that comes with
the
Access Workbench
Access
2000/2002/2003 Export To Text Bug/Safety Measure
to jump to the next page in the protection samples loop.Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
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
Access 2003 Security
