|
Regina Whipp |
|
The difficult I do immediately, the impossible takes a little bit longer. |
|
Modules |
To repair a MISSING or broken References... |
|
1. In the Database Container click on Forms and select any Form… |
|
3. On the Menu Bar click Tools... |
|
4. Then References... |
|
5. In the References window resolve any References that have a prefix of MISSING and/or…
...You see one in the example that you do not have checked. |
|
Access 2007 menu |
|
Access 2007 |
|
Access 2003 menu |
|
Access 2003 |
|
!!!Conversion Alert!!!
If your database has been converted up from Access 97, you may have some References checked that you no longer need. These References will also cause you problems in your newly converted version. Uncheck the Reference, 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 (Is not supported in Access 2007) Microsoft Visual Basic for Applications Extensibility 5.3 Microsoft Windows Common Controls 6.0 (SP6) (Unless you are using Common Controls this is not needed) |
|
6. With the module still open, select Debug from the Menu, then Compile. If the modules do not compile there may be additional unresolved references. Go back to Step 3 and continue until you can Compile with no errors. |
|
2. On the Menu Bar select the Code button (circled in red)... |
|
In Access 97 press Ctrl-G on your keyboard and then go to the Tools menu. The first choice is References. |
|
Access 2000 and above... |
