Home Access Archon Code Samples Bibliography Office Books Downloads Links Helen's Handknits

The following files are Access 2002 versions of the sample databases for my book, Access 2002 Inside-Out (some of these databases are in Access 2000 format):

bulletAll the sample databases (4,634K)
bulletControls 2002.mdb (533K)
bulletCrafts 2002.mdb (545K)
bulletExport 2002.mdb (740K)
bulletLink and Import 2002.mdb (724K)
bulletMacros 2002.mdb (548K)
bulletModified Northwind 2002.mdb (341K)
bulletSplit and Concatenate.mdb (42K)
bulletTest Database.mdb (464K)
bulletTest Access 2002.mdb (698K)

The following files are Access 2000 versions of the sample databases for my book, Access 2002 Inside-Out:

Note:  One database, Test Access 2002.mdb, is not provided in an Access 2000 version, because it consists mostly of Access 2002-specific material related to PivotCharts, PivotTables, and the Printer object.

 

bullet All the sample databases (3,363K)
bulletControls 2000.mdb (452K)
bulletCrafts 2000.mdb (708K)
bulletExport 2000.mdb (657K)
bulletLink and Import 2000.mdb (319K)
bulletMacros 2000.mdb (461K)
bulletModified Northwind 2000.mdb (266K)
bulletSplit and Concatenate.mdb (42K)
bulletTest Database.mdb (463K)

Here's a list of other useful files to download:

bullet Opening a Saved Outlook Template (.oft file) in Office 2003 or 2007 (309 KB)
Tells you what you have to do in order to open a saved Outlook template file, now that a recent update to Office 2003 has removed the old method of just double-clicking an .oft file to open it.
 
bullet

 

Access 2007 Save to PDF Add-in (915 KB)
A Microsoft add-in that lets you create PDFs directly from the Access 2007 Ribbon (and in code).

 

bullet Installing an Outlook COM add-in in Vista (364 KB)
My White Paper on navigating Vista security to get an Outlook COM add-in installed.

 

bullet

 

Installing an Access add-in in Office 2007 and Vista (181 KB)
My White Paper on navigating Vista security to get an Access add-in installed.

 

bullet Dealing with Macro Security (1,011 KB)
My White Paper on dealing with macro security for Word and Outlook, in Office 2003 and 2007.

 

bulletWindows Script 5.6 (617 KB)
Windows Script containing Visual Basic Script Edition (VBScript.) Version 5.6, JScript Version 5.6, Windows Script Components, Windows Script Host 5.6, and Windows Script Runtime Version 5.6.  This page lets you download the appropriate version for your OS and language.

Note:  Microsoft updates these files frequently, and sometimes moves them to new pages.  If this link is broken, you should be able to get to its new location by checking the Scripting Technologies page of the Microsoft Web site.

 

bulletscripten.exe (488 KB)
Windows Script containing Visual Basic Script Edition (VBScript.) Version 5.5, JScriptR Version 5.5, Windows Script Components, Windows Script Host 2.0, and Windows Script Runtime Version 5.1.  This file is for Windows 2000.

Note:  Microsoft updates these files frequently, and sometimes moves them to new pages.  If this link is broken, you should be able to get to its new location by checking the Scripting Technologies page of the Microsoft Web site.

 

bulletAcLicn97.exe (82 KB)
Fixes problem with "No license to run Access on this machine" after reinstalling Access 97.  This fix only works for Windows 98 systems.  See KB article Q141373 for more information on a possible workaround for other Windows versions.

 

bulletCDialog.zip (1,535 KB)
VB 4.0 Dialog app (installs CommonDialog control for use in Outlook)

 

bulletSnpvw90.exe (1,789 KB)
Report Snapshot Viewer for Access 97 and Access 2000.  Enables users who don't have Access to view Access snapshots.

 

bulletoutlflds.zip (46 KB)
My White Paper on Outlook 97 Fields and Properties, useful for Outlook programming

 

bullet DocProps.zip (47 KB)
My White Paper on Adding Custom Doc Properties to Word Templates, useful for working with Word documents in VBA code.  Covers Word 2000-2007.

 

bulletMOD_WOW.zip (46 KB)
My White Paper on Microsoft Office Developer 2000 (MOD), including details on ActiveX controls.