Conrad Systems Development

Conrad Systems Development


  Home

  B.O.$.$

  Client List

Access Information
  Resources
  Calendars
  Corruption
  App Close Button
  Macro Security
  Kick Them Off
  Database Splitting
  Combo Boxes
  Tab Colors
  Progress Bars
  Backgrounds
  Navigation
  Command Buttons
  References
  Demo Database
  Form Resize
  TreeView Control
  Switchboard FAQ
  Matching Games
  Top 10 Lists
  CSD Tools
  Technical Articles
  Document Tables
  Calculators
  Shift Key Bypass
  Epson Printer Info
  Newsgroup Help

  Contact Us


                                 Fixing Missing References 
                             

The arch-nemesis of Access is missing references. Listed below is some information on fixing broken or missing references in your database.

To fix the References problem follow these steps:
- Open any module in Design view.
- On the Tools menu, click References.
- At least one Reference should say "Missing". WRITE down the one(s) missing.
- Click to clear the check box for the type library or object library marked as "Missing:."
- Close the References Window box.
- Open the References Window back up. Hopefully, nothing should say Missing this time.
- Now go find that library/project(s) in the list that was missing.
- If more than one were missing, find the others and check them as well.
- Close the References box again.
- Now re-compile again. Debug--Compile.
- Hopefully you should not see any more compile errors.

If you'd like to read more about References, here's more info than you could possibly ever want to know:

  http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

  http://allenbrowne.com.au/ser-38.html

  http://www.trigeminal.com/usenet/usenet026.asp

  http://www.papwalker.com/dllhell/index-page2.html

http://www.access.qbuilt.com/html/ado_and_dao.html

References that you must set when you use Microsoft Office Access 2003:
http://support.microsoft.com/?id=825796 

ACC2002: References That You Must Set When You Work with Microsoft Access:
http://support.microsoft.com/?id=283115 

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/?id=248941 

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/?id=310803

List of the references that you must set when you work with Access 2000 or Access 97 database:
http://support.microsoft.com/?id=197110 

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/?id=175484 

ACC: VBA Functions Break in Database with Missing References
http://support.microsoft.com/?id=160870

 


Top Top

Copyright 2005-2010 Conrad Systems Development - All Rights Reserved

This page was last updated on Sunday, September 19, 2010.

Site created with FrontPage