Microsoft KB Archive/920275

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

Article ID: 920275

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Access 2007

-





SYMPTOMS
After you enable content for a Microsoft Office Access 2007 database, the parent database is disabled when you add a reference to a different Access 2007 database. You expect the parent database to remain enabled, or you expect a security notification to appear when the database status changes.

When you remove the reference, the parent database is automatically enabled again.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the behavior
 Start Access 2007. Click the Microsoft Office Button, and then click New. Click Blank Database, type DatabaseName1 in the File Name box, and then click Create. On the Create tab, click the arrow under Module in the Other group, and then click Module.  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 &quot;Library_Name&quot; End Sub  On the File menu, click Save DatabaseName1.</li> In the Save dialog box, select Module:Module1 under Save changes to the following objects, and then click Yes.</li> In the Save As dialog box, click OK.</li> On the File menu, click Close and Return to Microsoft Office Access.</li> Click the Microsoft Office Button, and then click Close Database.</li> Click the Microsoft Office Button, and then click New.</li> Click Blank Database, type DatabaseName in the File Name box, and then click Create.</li> Click the Microsoft Office Button, and then click Close Database.</li> Click the Microsoft Office Button, and then click Open.</li> In the Open dialog box, select DatabaseName, and then click Open.</li> In the Security Alert dialog box, click Enable Content.</li> In the Trust in Office dialog box, click to select Enable this Content, and then click OK.</li> On the Database Tools menu, click Visual Basic.</li>  In the Immediate window, type the following command: x=9 Print x Notice that the output is 9. </li> On the Tools menu, click References.</li> In the References - DatabaseName dialog box, click Browse.</li> In the Add Reference dialog box, click Microsoft Office Access Databases (*.accdb) in the Files of type list, select DatabaseName1, and then click Open.</li> <li>Click OK to close the References - DatabaseName dialog box.</li> <li> 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. </li> <li>On the Tools menu, click References.</li> <li>In the References - DatabaseName dialog box, click to clear DatabaseName1, and then click OK.</li> <li> In the Immediate window, type the following commands: x=9 Print x Notice that the output is 9. </li></ol>

<div class="references_section">

AC2007 ACC2007 Access2007

Keywords: kbtshoot kbprb kbexpertisebeginner KB920275

-

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

© Microsoft Corporation. All rights reserved.