Next Tip  Samples of how to backup and recover your Access database

The samples shown on this page are for owners of The Toolbox. ... 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 Next Tip to jump to the next page in the protection samples loop.

 

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
  • Get Good Help
    If you need help with a database, our Australian Professionals could be the answer

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection. 

    Purchase Smart Access

  • The Workbench
    Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions,  shutdown database

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc. Includes one of Smart Access downloads.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.
  • Purchase the Popular FMS Products  
    If you purchase the Popular FMS products from us, you will receive a complimentary of Smart Access Gold, Silver or Bronze Collections [Your choice]

 

 

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

MS Access Security

Read More here