As a result of many years of experience and hard-learned lessons, the following compilation of useful links to articles, forum threads, websites, and generally helpful resources is being made available to you. They cover a wide range of subjects (mostly Access, of course) but still all very informative. Often the discussions referenced are quite in depth and you'll have to do some reading, but sometimes the most successful accomplishments in life are realized when we reach them on our own merit.

If you think you have an article or website that is deserving of being in this list, well ... this is a Wiki ... feel free to add it yourself! Please try to attribute credit where it is due, and mark each new entry with a date, so that others can tell whether there is new content.

Please consider your contributions to this list carefully. They should represent hard-won knowledge, insightful points of view, cutting edge technologies, time-tested techniques, and outstanding examples of quality and professionalism.

UtterAccess hopes you will find this collection of links both helpful and valuable.

ADO

• ADO Connection Class Leigh Purvis
• Bind ADODB recordset to form
• DAO vs ADO - The latest viewpoints Walter Niesz
• Asynchronous ADO execution & progress meter

ADP (Access Data Projects)

• Microsoft ADP Info
• Optimizing Microsoft Office Access Applications Linked to SQL Server
• SP Parameter Discussion

API (Application Programming Interface)

• AllAPI.net - Your #1 source for using API-functions in Visual Basic!
• API BrowseFolder Dialog
• API Call the standard Windows File Open-Save dialog box
• API Get Login name
• API Shell and Wait
• Convert Currency into words (Five Hundred Dollars)
• The Access Web - APIs Index of Articles

Array

• Sort Array
• Sort Array w/API

Articles

• Smart Access Columns Doug Steele

AutoNumbers

• @@Identity
• @@Identity with CurrentDB
• Add Record VBA or SQL, return new primary key
• ADO @@Identity
• Autonumbers - What they Are and Are Not...
• Increment + 1

AutoUpdaters

• AutoUpdater Links
• AutoUpdaters - How to update a split database
• AutoUpdaters - Install FE onto local machine
• FE Updaters
• Auto FE Updater - also creates shortcuts, trusted locations, initial setup via email and more.

Database

• Compact and Repair -- Why How and How Often
• Decompile - SaveAsText
• Decompile, Compact and Repair
• Deploying Access 2007 Runtime-Based Solutions
• How to keep a Jet 4.0 database in top working condition
• Microsoft Access Performance FAQ
• Order of events for database objects - Access - Microsoft Office Online
• Preventing Modifications wtih .ACCDE
• Sell an application, with a subscription based system

Database - Deployment

• ACC: How to Create a Custom Database Version Using DAO
• Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions
• Control Access options at start-up (Autoexec)
• How do I create an MDE, ADE, or ACCDE file Walter Niesz
• Inno Setup - Free Installer
• Preparing Your Access 2003 Database for Deployment, Part 1
• Preparing Your Access 2003 Database for Deployment, Part 2

Database - Multiple Users

• Best Practices When Using Microsoft Office Access 2003 in a Multi-user Environment
• Connect to an ODBC data source with Prompt
• Current User (Network Name)
• Current Users logged on to a networked database
• Detect User Idle Time or Inactivity
• Kallal - Split your database
• Kick users out of the database when they've been idle too long.
• Manage Remote Back-End MS Access Database Programmatically With VB Code
• Remote Updates of a Back-End Database
• Sharing an Access Database Walter Niesz
• Split DB Optimization
• Split the Database
• Splitting a Secure Database

Database - Planning/Normalization

• argeedblu's FAQ on Design Strategies
• Avoid Composite Primary Keys
• Building an Access Database From the Ground Up
• Data Modeling Resource Center
• Database Design Resource Center
• Database planning tutorial Part I
• Database planning tutorial Part II
• Description of the database normalization basics
• Fully Qualified Naming - The First Step To Normalization
• FunctionX Tutorials
• GroverParkGeorge's PDF on Normalization
• Jerry's FAQ on Glossary
• Jerry's FAQ on Normalization
• 'Kick-Start' Data Models for Database Designs
• Naming Conventions - Hungarian Notation
• New to MS Access? Suggested Readings & Things
• Noah's FAQ on Normalization, Part 1
• Primary Keys - Natural vs Surrogate
• Principles of Entity Relationship Modeling: Get IT Right.
• Reddick VBA Coding Conventions
• Reddick VBA Naming Conventions
• Rules of Data Normalization
• Steps for Documenting a database
• Storing Calculated Values and Audit Trails
• Techniques for Uniquely Identifying Database Records
• The Evils of Lookup Fields in Tables
• The Ten Commandments of Access
• Understanding Normalization

Email

• How to send hidden email message
• Outlook Send E-mail Without Security Warning
• Send e-mail without CDO
• SMTP to send email from Access

Error Handling

• Chip Pearson, Error Handling in VBA
• FMS Inc., Error Handling

Encryption

• Encrypt and De-Crypt a table with this code
• Encryption

Excel

• Import Mixed Data columns from Excel

Expressions

• Additional Serialize Functionality
• Calculate Age Ricky Hicks
• Concatenate Address
• Concatenation of empty fields
• Date-Time Return Dates in US #mm-dd-yyyy# format
• Expressions to extract portion of a name in Access
• Inventory Control Quantity on Hand
• Nulls and their Behavior Brent Spaulding
• Sample expressions to extract portion of text string in Access 2000
• UK and US date format in SQL statement in VBA
• Understanding Carriage Returns, ASCII Codes, and Other Unprintable Characters Walter Niesz

Files

• How to Import a Text File That Has an Extension That Access Does Not Recognize
• Read in entire file at once
• Schema.ini File (Text File Driver)

Forms

• Adjusting controls to fit in form
• Combo Box -All- usage
• Conditional Formatting on Continuous Form With Six Conditions
• Form Resizer - Jamie's Software
• How to update form-subform all at once
• If combo box is blank return all records (parameter query)
• Make combo box appear like regular toolbar drop-down
• Open form at cursor location in continuous form
• Performance Timer
• Progressively Filter a Listbox by a Textbox
• Recordset + Unbound Control + Continuous Form
• Refer to Form and Subform properties and controls
• Referring to embedded form (subform) controls (Illustrated) Walter Niesz
• Resize form to work with all resolutions
• Translucent Forms
• Use NotInList Event to Add a Record to Combo Box

Internet

• Getting started with web apps
• HTTP POST

Links

• Good Links
• http--www.insomniasec.com-publications-Access-Through-Access.pdf
• IntuiDev - Resources (Interesting samples)
• Trigeminal Software (MichKa's site)

Modules

• Debugging Techniques Walter Niesz
• How to Click on IE link using VBA
• Reference Problems Doug Steele
• Return Single Value from Connection into VBA
• Use Class to define behavior of controls

MySQL

• Access to MySQL converter
• Access to MySQL on different servers
• Connection Strings for Shared Hosting
• How to convert Access BE DB to MySQL
• MySQL AB Visual Basic - MySQL Datatypes
• MySQL query parser/organizer
• MySQL Relationships
• Setting up MySQL and Access
• Connect to MySQL through VBA code

ODBC

• ODBC Basics
• Using DSN-Less Connections

OS

• Barts Preinstalled Environment (BartPE) bootable live windows CD-DVD
• Change Access Icon for single file
• UBCD for Windows

Queries

• How to implement Query by Form (QBF) with dynamic QueryDef in Access 2000
• Query Tips and Techniques
• Remove Duplicate Records
• Sub-Query in Query-Column Expression a.p.r. pillai
• Use Path in Query

Reference

• ACCESS Basics for Programming Crystal Long
• Access Developer Edition Versions
• Access Reserved Words
• Interactive Access 2003 to Access 2007 command reference guide - Access - Microsoft Office Online

Reports

• Change report font based on size of characters in twips
• How to create a running totals query in Microsoft Access
• How to provide row sequence numbers in a report
• Make and view access reports on the web
• MS-Access Report and Page Totals a.p.r. pillai
• Set the zoom percentage in a report

RunTime

• Runtime Directions - Discussion
• Runtime version of Split Database on one PC

Security

• Access Security Joan Wild
• Determine User Groups
• Logon Form with Custom Security Dane Miller
• The Microsoft Access Security Apparatus
• ULS and multiple DBs

SQL Server

• Access to SQL Server
• Beginning SQL Server Development Leigh Purvis
• Begin-Rollback Transaction
• Brand New to MS SQL - Where do I start
• ConnectionStrings.com - Forgot that connection string? You will find it right here!
• How do I store-retrieve text and image data in SQL Server
• Main Differences Between Access and SQL Server
• SQL Server Functions
• SQL Server Migration Assistant for Access (SSMA Access)
• Transact-SQL Reference
• XPSMTP - Send Mail From SQL Server

Tables

• Linked Tables - Read Only
• Memo field truncation

Terminal Server

• Printers That Use Ports That Do Not Begin With COM, LPT, or USB Are Not Redirected in a Remote Desktop or Terminal Services Session

Tools and Add-Ins

• Dependency Checker (freeware)
• Crystal's Data Dictionary (freeware)
• MZ Tools (freeware)
• SQL Formatter (freeware)
• TM VBA Inspector (donation requested)
• V-Tools for VB/VBA (freeware)
• EZY SQL Editor and Builder (small licence fee)
• EZY Documenter Premium (small licence fee)
• 4TOPS Query Tree Editor (licence fee)
• 4TOPS Excel Import Assistant (licence fee)
• 4TOPS Mail Merge (licence fee)
• Code VBA (licence fee)
• Help Generator (licence fee)
• Pretty Print Add-in (free unsupported product)
• Utilities Add-In (freeware)
• VBA Code Writer (freeware)
• Designer for Access from OpenGate Software (licence fee)
• Dashboard Builder for Access from OpenGate Software (licence fee)
• UI Builder for Access from OpenGate Software (licence fee)
• Web 2.0 effects for Access from OpenGate Software (freeware)

Treeview Controls

• Informal Treeview Documentation (O'Reilly Visual Basic Controls in a Nutshell, Evan S. Dictor sample chapter preview)

Tutorials

• ACC: Dlookup() Usage, Examples, and Troubleshooting (95/97)
• Access Developer Portal (Access 2007)
• Allen Wyatt's Learn Access Now
• Free Tutorials from DataPig Technologies
• How to Work With Attachments In DAO

UI Design

• Guidelines for Keyboard User Interface Design (MSDN - not Access specific)
• VB Key Code Constants (MSDN - vb6.0 specific, works with Access)

Utilities

• AutoHotkey - Free Mouse and Keyboard Macro Program with Hotkeys and AutoText
• ByPass Shift Key Utility for Access 2000, 2002 and 2003 Ricky Hicks
• Calendar Links
• Cardinal Text Format in Access a.p.r. pillai
• Disable Mouse Wheel
• Insert TAB in Memo Field
• Microsoft Access Popup Calendar
• Microsoft Access To open Open Dialog box from Access
• Multiple Control Selector (Time Picker Example) Walter Niesz
• Repairing Compacting Database with VBA a.p.r. pillai
• Resize-Resample Picture from code
• RichText
• Search and Replace Access Objects Brent Spaulding
• Sendkeys for Print Screen (PRTSCR)
• Spell check single record
• String Concatenation in a query (Flatten Data)

Variables

• Public Variable Options