Links to Access resources beyond this website

Last updated: 14 Aug 2016


Allen's blog (not related to Access) is called Seeking the Kingdom.

Forums

With the Microsoft newsgroups closed in June 2010, you can post questions requesting help in these forums:

Site Description and sub-links
Microsoft Access for Developers (MSDN forum), Microsoft Answers (Office forum)
Utter Access Discussion forums and wiki.
Access Programmers (UK) Access discussions
Usenet Requires a news reader, or use groups.google.com to search for comp.databases.ms-access

Free Access sites

Site Description and sub-links
Microsoft Knowledgebase. Template and sample databases. The Office Access and Access 2007 help sites (includes articles by Allen Browne) Access 2010 runtime. Access 2007 developer extensions, runtime, adding programs to 2007 deployment packages, Office 2010 developer references. Blogs by the Access Team and Clint Covington. SQL Server migration assistant for Access.
Access Web Page Official site of the Microsoft Access MVPs: API, Bugs, Tables, Queries, Forms, Reports.
Stephen Lebans Print PDF, Rich text and bold, Rotate text, lines/controls that grow, Mouse wheel off, Animated gif, Transparency, Save Relationship views.
QBuilt Articles by Tom Wickerath and others, Gem Tips (VB Editor Options, etc), Unable to create an MDE,
How-To (conversion, fixes, forms, queries, reports, security, VBA, and workarounds)
Tony Toews Tips, downloads, fixes, user groups, Performance FAQ, Email FAQ, FE Updater, Runtime versionsDevelopers Edition fixes.
Jeff Conrad Access Junkie: Database Documenter, Switchboard FAQ, Resources, Normalization links, Access 2007 info, Access 2007 Help Topics, Access 2007 FAQ
Access-Freak.com Access 2007 site by Access MVP Oliver Stohr. Tutorials and blog.
Alex Dybenko Tips and tricks, Access blog.
Doug Steele Doug's articles for Smart Access. Extended DateDiff(), Reference problems, DSN-less connections, List fonts.
Graham Seach Code such as fading forms.
Roger's Access Library Sample databases from Roger and others.
Peters Software Shareware, freeware, sample code.
John Nurick Code for file/string handling, Regular Expressions in VBA, Perl scripts, sample to import Microsoft Works data.
John Viescas Access author and MVP. Book selections, tips, downloads.
Arvin Meyer Sample database solutions.
Hook'D on Access Duane Hookom's sample databases, including simple calendar layouts built by setting MoveLayout to No.
Ken Snell Sample databases, Excel import/export
Candia Computer Consulting Al Campagna's tips and downloadable examples, e.g. "Continued" on report group headers, custom tool tips.
J Street Tech (Armen Stein) Tools such as relinker for multiple back ends. Zip files for: Access and SQL Server, Security, Report selection, Tools, Data Dictionary, Converting flat files.
Drewslair Microsoft Access and Visual Basic for Applications tutorials, from Andrew Comeau.
Trigeminal Michael Kaplan on replication, internationalization, version conflicts, references. His blog also covers topics like What does DAO have that ADO/ADOx/JRO do not?, In case of conflict, dump the indexes!, How to get at Jet warnings that are not errors
Data Pig Technologies Tutorials, demonstrating Access techniques. Uses Flash.
Steve Schapel Blog and anecdotes of how Access is used in the real world. SMS and FTP from Access.
RVBA Naming Conventions Naming conventions for objects and variables in Access.
AccessRibbon.com How to create and manage ribbons for Access 2007, by Avenius Gunter. Also in German.
DB Container for Access 2007 Database Window for Access 2007 (like previous versions), by Avenius Gunter. Also in German.
Asken.com Free sample databases for Assess Tracking, Contact Management, Event Management, Expenses, Inventory Control, Ledger, Order Entry, Resource Scheduling, Service Call Management, Time and Billing. (Requires email address.)
MyAccessProgram Tips and videos
Stuart McCall Code and tips, downloads e.g. FTP client 
Spell Checker (open source) Spelling checker for Access 97, 2000 and 2007. Works with rich text, and runtime. Open Source. From PCE Soft.
Bob Larson Samples and tutorials from BTAB Development.
Dev Hut The Developer's Hut tips, tricks, resources.
Total Hero Access tutorials
Other Access 2007 links Other links for Access 2007
David Fenton JET Replication, class module to replace FileSearch object, ...
Tigeronomy From John Mishefske: VBA/HTML converter, code samples, downloads to compare Access files, create wizards (A2007.)
Cypris’ lookout Blog on Access and other topics, e.g. enhanced MsgBox, transparent modal dialog.
Regina Whipp Access tips from Gina (MVP)
Andrew Plaisted Tips and tutorials for Access 2000 and later.
Philipp Stiefel German and English tips for MS Access, from Philipp Stiefel (MVP) new

Tutorials

Site Description and sub-links
FunctionX.com Access tutorials (including Access 2007)
BCSchools.net Introductory tutorials
Florida Gulf Coast Uni Introductory course for Access 2007, or Access 2000
Teachers on the Web High-school student level tutorials.
Technology Tutorials Basic tutorials in PDF format.
Access basics 8 tutorials by Crystal (Access MVP) in PDF format.

Access books on-line

Title Author Description
Mastering Access 95 Development Alison Balter All 35 chapters.
Database Design Principles Steven Roman Chapter 4 of Access Database Design and Programming (2nd Ed)
Building Microsoft Access Applications John L Viescas Chapters 4 - 8
Protecting Your Database with Startup Options Garry Robinson Chapter 2 of Real World Microsoft Access Database Protection and Security
Controlling Your Printer Paul Litwin, Ken Getz Chapter 10 of Microsoft Access 95 Developer's Handbook
(This link is currently broken, but here's the sample database.)
Application Optimization Paul Litwin, Ken Getz, Mike Gunderloy Chapter 15 of Microsoft Access 2002 Desktop Developer's Handbook
Exploring a desktop database
Create a database using templates
Build forms using Design Tools
Automate applications with macros
John Viescas, Jeff Conrad Excerpts from Access 2007 Inside Out
Hardcore Visual Basic Bruce McKinney VB techniques (not specifically VBA.) All 11 chapters. Link requires Java.
Creating Dynamic Ribbon Customizations
Using Code to Add Advanced Functionality to Forms
Rob Cooper, Michael Tucker Excerpts from Expert Access 2007 Programming

For understanding the query language in Access: SQL Queries for Mere Mortals by John Viescas and Michael Hernandez.

Commercial Access sites

Site Description and sub-links
EverythingAccess.com Professional database repair service, MDE to MDB conversion, SimplyVBA global error handler, forums, tutorials e.g. avoid email security warning.
Access Emergency Professional Access Recovery Services for damaged databases, with self-help.
FMS White papers, tips, quality utilities, Error List.
Rick's Find And Replace Add-in utility to identify/rename fields throughout the database.
Smart Access Access developers newsletter, as archived by Garry Robinson.
Access Advisor Developer magazine. Articles such as Bang vs. Dot
Superior Software for Windows Focused on SQL Server and .NET, but includes an Access FAQ and products.
VB123 Author Gary Robinson's articles on Access, security, programming, and the Access Unlimited newsletter.
ACG Soft Access Design Tips and Utilities.
MCW Tech Downloads for the Access Developer Handbook from Ken Getz et al.
K-Alliance Microsoft Access courses. Videos (YouTube).

Other related sites

Site Description and sub-links
Database Dev (UK) Database design and implementation articles, tips, tricks, code samples.
Library of data models Relational data structure examples for specific needs.
SQL Course Tutorials in Structured Query Language (the query language in Access and other databases.)
VBnet Visual Basic Developers Resource Centre. Code. Examples. FAQ. API calls.
Karl E Peterson's Classic VB Visual Basic code samples.
Joel on Software General software design principles and guidelines.
Usenet archive (Google) Search for posts in these groups: comp.databases.ms-access or microsoft.public.access.*
MZTools VBA utilities to automatically insert error handler code etc.

Information that can be hard to find

Topic Description and sub-links
Startup options Programmatically set the global options in Access 2000 or Access 2003.
Query ShowPlan Application Optimization (MSDN, Microsoft)
Use Microsoft Jet's ShowPlan to write more efficient queries (Susan Sales Harkins and Mike Gunderloy)
White Paper for Jet 3.5 (Access 97) performance: v35perf
Updates/service packs Service packs for Office, and JET 4. Listed separately, Office 97 and JET 3.5.
Wildcard characters Access wildcard character reference
Solutions sample database Download Orders and Developer Solutions
Order of events Microsoft's explanation of the Order of events for database objects: controls on forms, records on forms, forms and subforms, keystrokes and clicks, reports and sections.

Errors

Topic Description and sub-links
Dash character Query Returns no Records with an Indexed Field That Contains Dashes
Solving Wizard problems Error Message When Running Access Wizards
Function errors in queries ACC2000: Cannot Use New Visual Basic for Application Functions as Expressions (Access 2000 only)
Can't add new record Errors Adding Record to AutoLookup Form
Query fails to complete Dual Processor Computer Hangs When Running Query (Access 97 only?)
Vertical text disappears Text that is in a text box control of a report or a form may not appear correctly in Access (Workaround: use the Arial CYR font.)

Home Index of tips Top