The parent database is disabled and you do not receive a notification message when you add a reference to a different database in Access 2007

Steps to reproduce the behavior

1. Start Access 2007.
2. Click the Microsoft Office Button, and then click New.
3. Click Blank Database, type DatabaseName1 in the File Name box, and then click Create.
4. On the Create tab, click the arrow under Module in the Other group, and then click Module.
5. In the Visual Basic Editor, replace the code in the DatabaseName1 - Module1 (code) window with the following:

   Option Compare Database
   Option Explicit
   Sub Library_Name()
   MsgBox "Library_Name"
   End Sub
   

6. On the File menu, click Save DatabaseName1.
7. In the Save dialog box, select Module:Module1 under Save changes to the following objects, and then click Yes.
8. In the Save As dialog box, click OK.
9. On the File menu, click Close and Return to Microsoft Office Access.
10. Click the Microsoft Office Button, and then click Close Database.
11. Click the Microsoft Office Button, and then click New.
12. Click Blank Database, type DatabaseName in the File Name box, and then click Create.
13. Click the Microsoft Office Button, and then click Close Database.
14. Click the Microsoft Office Button, and then click Open.
15. In the Open dialog box, select DatabaseName, and then click Open.
16. In the Security Alert dialog box, click Enable Content.
17. In the Trust in Office dialog box, click to select Enable this Content, and then click OK.
18. On the Database Tools menu, click Visual Basic.
19. In the Immediate window, type the following command:

    x=9
    Print x

    Notice that the output is 9.
20. On the Tools menu, click References.
21. In the References - DatabaseName dialog box, click Browse.
22. In the Add Reference dialog box, click Microsoft Office Access Databases (*.accdb) in the Files of type list, select DatabaseName1, and then click Open.
23. Click OK to close the References - DatabaseName dialog box.
24. In the Project - DatabaseName(DatabaseName) window, click DatabaseName, and then type the following command in the Immediate window:

    x=9
    Print x

    Notice that the output is blank.
25. On the Tools menu, click References.
26. In the References - DatabaseName dialog box, click to clear DatabaseName1, and then click OK.
27. In the Immediate window, type the following commands:

    x=9
    Print x

    Notice that the output is 9.

Back to the top