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.
Back to the top
Microsoft Access 97 does not check for new references when you open a
Microsoft Access 7.0 database.
Back to the top
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.
Back to the top
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.
Back to the top
