While I am committed to using Microsoft Access, I'm afraid I spend more time (some, like my wife, might say too much!) hanging about answering questions in the microsoft.public.access.* newsgroups, as well as computer.databases.ms-access newsgroup. To this end, I've been honoured by Microsoft by being named a MVP (Most Valued Professional). See my MVP profile. The fact that I answer questions in the newsgroup should not be taken as an implication that I'm willing to answer questions via private e-mail.

I believe in newsgroups. Sending private e-mail, to my mind, defeats the purpose of the newsgroups. First, it's of less benefit to you, since now you're tied to me having to check my e-mail, find time to reply, etc., whereas if you post to the newsgroup, someone else may be able to answer your question instead of me. As well, if you have a particular problem, odds are someone else out there has the same problem, and they won't benefit from private e-mails. Remember, too, that everything posted to the newsgroups gets archived at services such as http://groups.google.com/advanced_group_search, so others can benefit for a long time (and perhaps I won't have to answer the question again <g>).

Interested in learning more about Templates in Access 2007? Have I got a deal for you! Zac Woodall has recently published a book entitled The Rational Guide to Microsoft Office Access 2007 Templates. If you'd like to purchase this book, use this link to learn more about the book, and save 40% off the list price of that book, or 35 other titles from Mann Publishing.

While you're waiting, check out some of the links that I've found useful in the past. I've started to find myself doing more in Visual Basic than Access these days, so I've added some VB links as well.

Access

The Access Junkie

Jeff Conrad, self proclaimed "Access Junkie", has accumulated a great set of references here

The Access Web

The best (bar none)

Allen Browne's Home Page

Includes, among other items, a good article about working with dates when your default is non-American.

Black Moshannon Systems (Speed Ferret)

Good Find & Replace utility that works with Microsoft Access, SQL Server, and Visual Basic

FMS, Inc.

FMS makes some very impressive utilities for MS Access

Microsoft Access 2003 VBA Language Reference

This download contains the Microsoft Office Access 2003 Visual Basic for Applications (VBA) Language Reference as a compiled Help file.

Microsoft Access Knowledge Base Help Files

Download the "official" Microsoft Access Knowledge Bases here (Access 97 and earlier only)

PK Solutions Home Page

For Microsoft Access related tools and services, including the most reputable Data Recovery Rescue Service for Microsoft Access

Rick Fisher Consulting (Find & Replace utility)

Another great Find & Replace utility for Access

Stephen Lebans's Website

Some amazing ways of achieving things you never thought you could in Access!

Superior Software for Windows (SSW)

Impressive utilities for Access, VB and .NET Developers

Tony's Main Access Page

Has good stuff on emailing and help. Also some very useful free utilities.

Trigeminal Software, Inc. (English)

MichKa has forgotten more about Access than most of us can ever hope to learn!

Trevors Home Page

A little dated now, but still has some good stuff.

vb123.com

Resources from Garry Robinson (and home of the Access Unlimited newsletter)

VB

Common Controls Replacement Project

Dedicated to providing better, smaller controls than Microsoft
(Alas, the project has chosen to disband. You can still download the results of their work, though.)

Home of Brad's VB-32 programs and samples

To quote Brad, "A unique collection of freeware programs and code samples catering to the intermediate and advanced Visual Basic programmer familiar with the Win32 shell, common controls, and API."

VBNet: The Visual Basic Developers Resource Centre

IMHO, this site (run by Randy Birch) is the VB site to visit!

YAW

L.J. Johnson's "Yet Another Web-page" is a little more than the title implies...

ADO

ADO Connection Strings

Carl Prothman has virtually every known ADO connection scenario described here.

My Stuff

A More Complete DateDiff Function

Calculate the difference between two date/time values down to the second.

An Alternative Database Documentor

An add-in (courtesy of Jeff Conrad, Access Junkie) based on a Smart Access column of mine

Dealing with Access Reference Problems

A detailed explanation of what causes the problem (most often characterized by having common functions like CurrentDB, Str$, Mid$, Date$, etc. stop working), and what can be done about it.

Fix your registry

How to fix your registry if you add Access 2.0 after you've added Access 97. (Yes, I know this is kind of out of date, but hopefully the principle will show you how to do it for other situations!)

"The Ten Commandments"

a paraphrase of The Ten Commandments of Access at "The Access Web". I didn't like the wording, so I've reworked it here.

Using DSN-less Connections

How to create linked tables that don't require a DSN.

Access Answer columns 2007/02/28 (A correction to the October, 2005 column)

My Access Answer columns from the Smart Access newsletter.

As well, here are some ancient sample databases I've created (MS Access 2.0, under Windows 3.1, although I have tested most of my code running 2.0 under Win'95) These files are the .MDB zipped up. I've tried to put sufficient comments in the code, but I know I haven't always succeeded!

List Fonts (24,830 bytes)

Work with Novell 3.x (22,854 bytes)

This page is maintained by Last Updated: 25th June, 2009