Microsoft KB Archive/163655

= ACC97: Reference Library Not Available in Enabled 97 Database =

Article ID: 163655

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



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.



Steps to Reproduce Behavior
 Start Microsoft Access 7.0 and create a new blank database.  Create a new module and type the following procedure: Function Test Msgbox "This is a test" End Function  Save the module as Module1 and close it. Quit Microsoft Access 7.0. Start Microsoft Access 97 and open the database you created in step 1.</li> In the Convert/Open Database dialog box, click Open Database. The version 7.0 database will be enabled for use in Microsoft Access 97.</li> As soon as the database opens, quit Microsoft Access 97.</li> Start Microsoft Access 7.0, and open the database that you created in step 1.</li> Click the Modules tab in the Database window, and then open Module1 in Design view.</li> On the Tools menu, click References.</li> 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.</li> Close the module and quit Microsoft Access 7.0.</li> 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.</li></ol>

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: kbprb kbprogramming kbusage KB163655

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.