Troubleshooting Problems with Microsoft Access
Troubleshooting an Access
database is fairly simple. There's several steps you should always take, and
it doesn't hurt to take them before the problems arise!
I've already told you about
repairing regularly. But what if you get errors when you open your database
or form or other object?
Begin immediately by creating a
new, blank database. Import the objects from your "bad" database into the new
one. Generally, this fixes errors where the cause is unknown or you didn't have
You don't have to
import all the objects in at once. You can pull some in, see if you get errors,
and then pull some more in.
Thanks to Bill Benson for this extra
You will also want to check all the references used in the old
database, if possible, and make sure they're checked in the new database. To do
this, open the Visual Basic Editor by hitting Alt+F11 or ToolsŕMacroŕVisual
From the Tools menu, choose References. Check any appropriate
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved