Fix an ACCESS reference to a library
In many cases, Microsoft Access will fix missing references automatically when you open an Access file. Use the following procedure if you need to fix a missing reference manually.
- Open a module or create a new module.
- On the Tools menu, click References.
- In the Available References box, clear the check boxes next to any missing references, and select the check box next to the reference or references you want.
It always seems to be the Excel reference when porting from one system to the next. Especially on an un-updated system.