Microsoft Access Protection - Book Links

Backing Up and Recovering Your Databases

Backups On Demand ?
The latest version of the Access workbench includes a really easy to use backup facility that runs soon after everyone closes the database.
Read more 		Is Your Database Secure ?
Need to know more about how to protect your database investment. Confused about Access security. Then have a look at the book that Garry is writing for Apress.
Click here for book link

Unusual text file imports
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306144

Using XML Exports to generate web reports.
http://www.databasejournal.com/features/msaccess/article.php/1384001

Search your Access 2000+ VBA help for the term "AddFromFile" to find out how to import modules into a database.

What causes Access corruption and how can we recover it
http://www.vb123.com/fixaccess

http://support.microsoft.com/directory/discontinue.asp

Since The Book Was Published

Tony Toews comments on backups.
 http://www.granite.ab.ca/access/backup.htm

Samples of how to backup and recover your Access database

How to transfer relationships between databases
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=12#12

A good page on database corruptions
 http://allenbrowne.com/ser-25.html

Helen Feddema's approach to backing up a database
http://office-watch.com/access/archtemplate.asp?5-16

Saving and Recovering Objects

In the section on saving objects to text (forms etc, if you save from an Access 2002 database, you must recover to an Access 2002 database.  ie loadFromText saveToText commands

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics

  • 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. 

    See the Smart Access 2010 specials here

  • 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.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.

 

 

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