ACC2000: May Lose Last Changes to Field When Closing a Page (223232)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q223232
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

Changes to the last field that you edit on a data access page may be lost when you close the page. You do not get a prompt to save this change or a warning that the change will be lost.

CAUSE

You changed the value in a field, and then closed the page without moving out of that field or saving the record.

RESOLUTION

Before you close a page, make sure that you either move the pointer out of the last field that you change or that you save the record.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages under Objects.
  3. Select View Products, and then click Open.
  4. Change the Product Name of the first record. Do not move the pointer out of that field.
  5. On the File menu, click Close.
  6. Select View Products, and then click Open. Note that the Product Name still has the original value.

Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbbug kbDAP kbpending KB223232