ACC97: Reference Library Not Available in Enabled 97 Database

Last reviewed: August 29, 1997
Article ID: Q163655
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

If you add a new reference to a Microsoft Access 7.0 database that has previously been opened in Microsoft Access 97, when you open the database again in Microsoft Access 97, you do not see the option to Open or Convert the database, and the new reference is missing.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to the "Building Applications with Microsoft Access 97" manual.

CAUSE

Microsoft Access 97 does not check for new references when you open a Microsoft Access 7.0 database.

RESOLUTION

To be sure Microsoft Access 97 will allow you to re-enable a version 7.0 database after you add a new reference, you must also modify a module in the database.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access 7.0 and create a new blank database.

  2. Create a new module and type the following procedure:

    Function Test()

              Msgbox "This is a test"
           End Function
    
    

  3. Save the module as Module1 and close it.

  4. Quit Microsoft Access 7.0.

  5. Start Microsoft Access 97 and open the database you created in step 1.

  6. In the Convert/Open Database dialog box, click Open Database. The version 7.0 database will be enabled for use in Microsoft Access 97.

  7. As soon as the database opens, quit Microsoft Access 97.

  8. Start Microsoft Access 7.0, and open the database you created in step 1.

  9. Click the Modules tab in the Database window, and then open Module1 in Design view.

  10. On the Tools menu, click References.

  11. Click any reference that is not already selected in the Available References box, and then click OK.

    NOTE: Do not make any other changes to the database.

  12. Close the module and quit Microsoft Access 7.0.

  13. Start Microsoft Access 97 and open the database you created in step 1. Note that you are not prompted to Open or Convert the database. Also, if you execute code that relies on the reference you created in step 11, you receive an error message.

If you make any change at all to Module1 in step 9, and then you save the change, Microsoft Access 97 will prompt you to Open or Convert the database, and the new reference will be included in the enabled database.
Keywords          : kbusage MdlLib CnvOthr
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb
Solution Type     : Info_Provided


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.