Allen Browne's Database and Training
no longer accepting clients
Welcome to Allen Browne's tips for Microsoft Access
Brief tutorials and help for novices and database developers. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities to download. All free.
This is literally an FAQ. It has grown in response to the most frequently asked questions in Access newsgroups, for 16 years. Each page explains the most efficient solution that works completely within Access, as simply as possible.
Re newer versions, see Converting to Access 2007 or 2010.
Allen is no longer accepting database clients.
If you don't know how to write code, these may help.
Solutions for developers.
Coding examples for VBA (Visual Basic for Applications.)
Developer reference section: create, delete, modify, and list the database objects (tables, fields, indexes, relations, queries, databases) and set their properties. Heaps of code, with only limited explanations.
See also the Index of VBA Functions - list of the code from all pages on this site.
Specific solutions and downloadable tools.
Service packs fix known bugs. To get the latest service pack for your version of Office, visit http://support.microsoft.com/sp.
The flaws listed below remain unfixed for at least three versions of Access. You must know how to work around them, or they will bite you. Flaws marked "Sample" are demonstrated in AccessFlaws.zip (Access 2000, 125KB).
Some of these describe cases where Access fails or crashes.
Cases where Access displays or handles data wrongly in forms and reports.
Issues you may encounter in changing version:
Microsoft also has an Access 2.0 Converter for Access 2003.
If you have a background in the old dBase/Foxbase, you may appreciate:
All tips and samples are offered without liability: use at your own risk.
You may freely use anything (code, forms, algorithms, ...) from these articles and sample databases for any purpose (personal, educational, commercial, resale, ...). All we ask is that you acknowledge this website in your code, with comments such as:
We are not able to give free support for all the free tips, utilities, and solutions in these pages. We will need to charge you if you email asking for support or help in implementing these ideas or completing your database.
For free help, see the Forums section on our Links page.
Occasionally, Access users offer to send something in gratitude. We prefer you give your donation to a child charity that provides education and health for children (such as Compassion.) Then drop us an email so we can share the pleasure of your gift.
To email Allen Browne:
For other contact details, see our home page.
Access 2000 and 2002 users:
Many of these tips require the
If Database or Recordset gives an "unknown type" error, set your References.
(All other versions have this reference by default.)
Last update: 30 Jan 2014