Please feel free to use any of these downloads for non-commercial purposes.
Database Application Best Practices.ppt
A powerpoint presentation on the "best practices" I use in Access application development. Presented to a group of SVP Partners in January 2007.
NewAppTemplate.zip
A zip file containing a single .mdb file, which is a framework for an Access Jet database application. The mdb contains all of the common forms and infrastructure described in the "Database Application Best Practices" powerpoint presentation. Note that you should move the tables in this database to a backend database; I just kept them together in one file for ease of deployment and testing.
NewAppTemplateCS.zip
A zip file containing a single .adp file, which is a framework for an Access Data Project. The adp contains all of the common forms and infrastructure described in the "Database Application Best Practices" powerpoint presentation. Note that you should use the Access Upsizing Wizard to move the tables and queries from NewAppTemplate.mdb (the previous download) to a SQL Server, and then point this adp's connection to that new database on SQL Server.
JetCompactUtilities.zip
A zip file containing the Microsoft JetCompact.exe utility, and a simple batch file to invoke it on an mdb file.
Demographic Standards.doc
http://www.cityofseattle.net/humanservices/outcomealignment/default.htm
The Outcome Alignment Group was formed in 1999 by United Way of King County, City of Seattle, City of Bellevue, and King County to agree upon common questions and answers for tracking cient demographics. The link above points to their site. The document above has the standard questions they come up with for demographics.
SmartGrid.zip
A zip file containing a Visual Studio 2005 project for the SmartGridView asp.net control.
A jpg of SmartGridView
