vb123.com

 

Home Page 
Order Our Software

The Workbench  Find out who is in your database, open the correct version of Access, easy compacting, switch workgroup files with no fuss Click Here

The Toolshed 
Ebook comprising of all the information at vb123.com plus hidden downloads etc. Click Here

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool.  Click Here

The Toolbox  Easy to use source code that you can import into your Access database. 
Click Here

Access Security 
Garry's book on Access Security will be hitting the streets soon. In todays Real World, can you afford not to have a secure database?

Note: You can find a good price if you
pre-order now at Amazon
Read More


Free Newsletter  Try our informative newsletter on Office Automation, Access and VB topics
Click Here

About The Editor Garry Robinson writes for a number of popular computer magazines. He lives in Sydney, Australia and runs VB123 and GR-FX.com
Contact Us ...

 

   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

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

 

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

Links >>>  Home | Search | Workbench | Orders | Newsletter | Table Of Contents | Access Security