|
Microsoft Access Protection - Book Links
|
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 |
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
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/toolshed/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/toolshed/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
Links >>> Home | Search | Workbench | Orders | Newsletter | Table Of Contents | Access Security |