Microsoft KB Archive/248965

= ACC2000: Changing Database Properties Can Cause Lost Objects in Access Projects =

Article ID: 248965

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q248965



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
In a Microsoft Access project, after you modify the Database properties, you notice that an object that you recently created is no longer there. This can happen with the following objects:
 * Forms
 * Reports
 * Data access pages
 * Macros
 * Modules



CAUSE
If you change the Database properties in an Access project, and then make changes to the project, any forms, reports, data access pages, macros, or modules that you create for the remainder of that session may be lost.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

To temporarily work around this problem, whenever you change the Database properties, immediately close and reopen the Access project before you continue.

NOTE: Microsoft Office 2000 SR-1 and this workaround only prevent you from losing any new objects because of this issue. Microsoft Office 2000 SR-1 and this workaround will not restore any objects that you lost because of this issue.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.



Steps to Reproduce Behavior
CAUTION: If you follow the steps in this example, you modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and follow these steps on a copy of the project.

 Open the sample Access project NorthwindCS.adp.

NOTE: If you do not have the NorthwindCS.adp file installed, you can create a new Access project, instead. On the File menu, click Database Properties. On the Summary tab, type the following text for the Subject property:

This is a test.

 Click OK in the Database Properties dialog box. Create a new form, and then save it as Form1.</li> Close the new form.</li> Close the Access project and reopen it.</li> Under Objects, click Forms. Note that the Form1 form is not there.</li></ol>

Additional query words: pra missing not there visible can't cannot see find gone vanished deleted any

Keywords: kbbug kbfix KB248965

-

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

© Microsoft Corporation. All rights reserved.