ACC97: Reference Library Not Available in Enabled 97 Database (163655)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q163655
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

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 that 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 that you created in step 1. Note that you are not prompted to Open or Convert the database. Also, if you run code that relies on the reference that 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.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbprb kbProgramming kbusage KB163655
©2004 Microsoft Corporation. All rights reserved.