vb123.com.au                                                          

   Microsoft Access Protection - Book Links

Good Programming Practices Provides A More Secure Foundation

To find out all about linking and importing data, search your Access 97 help for “Import or link data”

To find out all about linking and importing data, search your Access 2000+ help for “Import or link data and objects”

The Access 2002 help contents has lots of content on linked tables as shown in the figure below

  << Click to expand

To improve performance, search your Access help (all versions) for “Improve performance of linked tables”

Microsoft Knowledge Base Article - 160951
Conditionally Run AutoExec Macro in Automation Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;160951

Hiding the database window by modifying the Autoexec macro
http://support.microsoft.com/default.aspx?scid=kb;en-us;88160

Read the article Garry wrote on the FileDialog object for Smart Access
http://www.vb123.com/Toolbox/03_docs/filedialog.htm

To find out more about the File Dialog object in Access 2002
http://msdn.microsoft.com/library/en-us/vbaof10/html/ofobjFileDialog.asp
http://msdn.microsoft.com/library/en-us/dnoxpta/html/odc_filedlgobjs.asp
 

The find out about the File Search object in Access 2002
http://msdn.microsoft.com/library/en-us/vbaof10/html/ofobjFileSearch.asp?frame=true

The Importance of Splitting Databases (pdf format)
Click Here

The solutions database is a source of a lot of good free material from Microsoft. It includes source code for re-linking tables. This page tells you where to download it.
http://www.vb123.com/Toolbox/99_free/solutions.htm

Error handling in Office VBA
http://msdn.microsoft.com/library/en-us/modcore/html/deconhandlingerrors.asp

Search your Access Visual Basic help for the following topics on Error handling
"The Error object" (for both DAO and ADO)
"DLL Errors"

Error handling in class modules
http://msdn.microsoft.com/library/en-us/modcore/html/deconerrorhandlinginclassmodules.asp

Search for "Linking With Passwords" will provide you with some interesting information on passwords and linking.

Error-Handling Supplemental Information
http://support.microsoft.com/default.aspx?scid=kb;en-us;101324

How to find Access error codes
http://support.microsoft.com/default.aspx?scid=kb;en-us;105666

View the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly
http://support.microsoft.com/default.aspx?scid=kb;en-us;289508

How to Turn Off "Break on All Errors" Option in Code
Access 97
http://support.microsoft.com/default.aspx?scid=kb;en-us;167855
Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;209884

Error search tool add-in for Access 97
http://support.microsoft.com/default.aspx?scid=kb;en-us;167742

Since the Book Was Released

The latest release of the Workbench now introduces a new table driven system for updating the version name and number
http://www.vb123.com/workbench/

Linking with passwords
http://www.larkfarm.com/sax/sax2-13.txt