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

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

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.

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: 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.

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.

1. 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.
2. On the File menu, click Database Properties.
3. On the Summary tab, type the following text for the Subject property:
   This is a test.
4. Click OK in the Database Properties dialog box.
5. Create a new form, and then save it as Form1.
6. Close the new form.
7. Close the Access project and reopen it.
8. Under Objects, click Forms. Note that the Form1 form is not there.