The difficult I do immediately, the impossible takes a little bit longer.

If your database has been converted up from Access 97, you may have some References checked that you no longer need and in some cases will cause you errors, such as, code crashes on opening Switchboard or Main Menu, code will act erratically** and/or some forms may not function. Close the database, make a copy and while holding down the [Shift] key reopen your database.  Go to References and uncheck the Reference(s), select Debug and then Compile and then close your database. Reopen as you always would. Here’s a list of a few References that you can uncheck with no consequences…

Microsoft Office Web Components [owc11.dll] ( Is not supported in Access 2007, 2010 or 2013 but can be downloaded here.)
Microsoft Visual Basic for Applications Extensibility [vbe6.dll] 5.3
Microsoft Windows Common Controls 6.0 [mscomctl.ocx] (SP6) ( Unless you are using Common Controls this is not needed and will clash with Access 2007, Access 2010 and Access 2013's internal Calendar Control )

Access 2013 will not convert or open Access 97 databases.  You will need a copy of Access 2003, Access 2007 or Access 2010, convert and then open with Access 2013.

In Access 97 press [Ctrl] + G on your keyboard and then go to the Tools menu. The first choice is References.

Open the any database and press [Ctrl] + G (on your keyboard) or if you have the database open you can select the *View Code* button (see red circle).

Next, we open the References...  On the Menu Bar click Tools... then References...  This menu is the same for all versions... 
The Reference window...
In the Reference window resolve any References that have a prefix of MISSING and/or…

...you have one that is not in the example AND you are not using.

And finally, with all the References resolved, select *OK* then select Debug (from the Toolbar), then Compile.  Fix any issues that may arise and try to Compile again.  Keep going till all issues are solved...

If the above does not resolve your issues or you can't get to the VB Editor, have a look here...

Access Reference Problems

Repair (or Remove) MISSING or broken References...
Access 2000 to Access 2003...

First, we need to get to the VBA Editor...

Access 2007 menu
Access 2010 (or Access 2013) menu
Access 2003
Access 2007
Access 2010
Access 2003 opened in Access 2010
In the Reference window resolve any References that have a prefix of MISSING and/or…

...you have ones that are not in the example AND you are not using.
In the Reference window resolve any References that have a prefix of MISSING and/or…

...you have ones that is not in the example AND you are not using.
How to use Windows System Colors   (Access 2003 and earlier)
Where are the Options?   (Access 2007 and higher)
Trusted Location   (Access 2007 and higher)
Export Specifications   (Access 2007 and higher)
Import Specifications   (Access 2007 and higher)
Navigation Pane Options  (Access 2007 and higher)

Design

Object Designers (Access 2007 and higher)
If you are having difficulty opening your database, hold down the Shift key (on your keyboard) until you see the Database Window or Navigation Pane and then press [Ctrl] + G.

Set Subdatasheet to None (Access 2003 and higher)

Access 2013
aaaaaaaaaaaaiii