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

ID: Q248965

The information in this article applies to:

Microsoft Access 2000

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 work around this behavior, whenever you change the Database properties, immediately close and reopen the Access project before you continue.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

CAUTION: Following the steps in this example will modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and perform 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.

Close the new form.

Close the Access project and reopen it.

Under Objects, click Forms. Note that the Form1 form is not there.

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

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug