ACC97: Reference Library Not Available in Enabled 97 Database

ID: Q163655

The information in this article applies to:

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 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.

Additional query words: 

Keywords          : kbusage CnvOthr MdlLib 
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb

Last Reviewed: November 21, 1998