|
vb123.com |
|
|
Home Contact Us Order our Software
RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has
your database open, start the correct version of Access, easy compacting and
backups, change startup options, mde compile, shutdown database
Read and Download
Garry's Blog
About The Editor
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
or try our Aussie
|
Is Your Database Corrupt
?
Microsoft Access Protection - Book Links
Good Programming Practices Provides A More Secure Foundation
|
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
<< 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/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
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