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



The information in this article applies to:

  • Microsoft Access 2000

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.

MORE INFORMATION

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.

Modification Type:MajorLast Reviewed:11/25/2002
Keywords:kbbug KB248965