Developer Downloads:

The following downloads are intended for personal and educational use.  If you intend to use one of the downloads for commercial purposes all we ask is that you  please give credit where credit is due and reference J Street Technology.

* Disclaimer: J Street Technology offers these downloads as is and does not assume any liability for bugs or problems with any of the code.  In addition, we do not provide technical support for these downloads.

  J Street Access Relinker

Here is the Access table relinking utility that J Street has used in all of our Access applications for years.  It is an essential tool after you have split your database into a front-end application and a back-end database.  It handles multiple back-end Access databases, checks your linked tables on startup, prompts your user to locate the back-end database if needed, and even has an automatic mode that relinks to local databases without prompting.  Access 2000/XP/2003/2007, 76 KB.

  TechEd 2008 - Managing Your Database Development Projects (DAT04-TLC)

Here is the slide deck that Armen Stein presented at the TechEd 2008 Developers Conference in Florida in June 2008.  Armen presents some techniques to help you manage your database projects so that both you and your customers stay happy. See example documents for planning the project, tracking questions, and communicating status (including the dreaded budget increase). Also see how you can use Microsoft Visio to sketch your application design and obtain approval from your customer. Learn techniques for estimating projects, which can be one of the most difficult challenges. Most of the presentation applies both to consultants and internal developers.  PowerPoint, 3M.

  TechEd 2008 - Microsoft SQL Server Data Solutions Using Microsoft Office Access (DAT303)

Here are the slides and sample materials that Armen Stein and Mary Chipman presented at the TechEd 2008 Developers Conference in Florida in June 2008.  Many techniques and examples for using Microsoft Access as a client-server front-end to SQL Server are included.  PowerPoint, Access 2000, text code samples, 6.34M.

  The Best of Both Worlds: Access-SQL Server Optimization

Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance.  This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of SQL Server while retaining the techniques you have learned in Access.  PowerPoint, 379K.

  Data Dictionary Report Utility

Can't get the built-in Access database documentation tools to give you the simple report you want? Here's the answer. This utility documents all the tables and fields in your database, linked or local, including field descriptions! Access 2000, 44k.

  Converting Flat Files into a Relational Access Database

This is the PowerPoint slideshow that Armen Stein, President of J Street, presented to the KEGS Access SIG. It shows how to tackle the problem of converting old "flat" data (from Excel, text or wherever) to your relational Access tables. Includes a sample database showing the techniques mentioned in the slides. PowerPoint 2000, Access 2000, 820K.

  Access Security Basics

These are the PowerPoint slides that Armen Stein, President of J Street, presented to the Pacific Northwest Access User Group. It describes various ways that you can secure an Access database, with some common mistakes that developers often make and tips to avoid them. PowerPoint 95 or later, 534K.

  Report Selection Techniques

Example of a pop-up report selection criteria form. This technique is great for allowing the user to choose which records will appear on a report, without using parameter queries! Other report techniques are shown also.  Access 2000 database and PowerPoint slideshow, 372k.

  Cool Tools

A sampler of labor-saving code and cool usability enhancements. Includes QuickDate, a "Quicken-style" method of using keys to increment date fields by day, week, month and year, and some handy name and address concatenation functions. Comes with a form demonstrating most of the tools - look in the code for more! Access 2000, 48k.

  User Interface Guidelines

Also known as "Beauty Is Only Skin Deep, But It Gets You Asked To Dance!". It's our approach to designing consistent, professional-looking forms. Word, 64K.

  A Better Record Finder

A quick and easy way of allowing users to find a record on a continuous form. Much easier for your users than the dreaded "binoculars"! And easy for you to code - just add a few lines of VBA to your form. Access 2000, 73K.

  Customizable Reports

This is a great way to provide custom reports to your users without spending a lot of development time. Allows selection and ordering of report sections, with the ability to save the layouts for others to use. Includes an article in Word and a sample database, 388k.