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
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.