Real World Microsoft Access Database Protection and Security

As you can expect, there is never enough information when it comes to powerful products like Access. To assist you with further investigations, I have put together a Web page with links to Microsoft's and other Web sites plus key words to use when searching Access help on the issues relating to material in this chapter, including the following:

• Conditionally running the AutoExec macro when using automation.

• Hiding the Database window by modifying the AutoExec macro.

• Key words to use in the Access help guides to find out about linking tables. For example, Access 2002 help has a lot of material on linked tables, as shown in Figure 4-13.

  Figure 4-13: Access help has a lot of material on linked tables.

• An article I wrote on the FileDialog object for Smart Access.

• The File dialog and the FileSearch objects in Access 2002.

• Where to download the Access 2000 solutions database. This database includes source code for relinking tables and many other useful coding samples.

• Error handling in VBA, errors with DAO, ADO, DLL, and in class modules.

• How to turn off the Break on All Errors option in code.

You can find the further reading Web page for this chapter in the Downloads section of the Apress Web site ( http://www.apress.com ) or at this address: http://www.vb123.com/map/goo.htm .