ACC2000: Created and Modified Dates for Objects Suddenly Reset (244642)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q244642
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you view the details of the objects in the Database window, you see that all forms, reports, macros, and modules have the same created and modified date. However, tables and queries have the actual date when they were created or modified.

CAUSE

This behavior occurs when you compact a database. Compacting a database resets the Created and Modified columns for all Access project items to the date and time when you compact the database. Access project items consist of all forms, reports, macros, and modules.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Access 2000.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. On the View menu, click Details.
  3. In the Database window, click Forms under Objects. Note the date and the time in the Created and the Modified columns.
  4. On the Tools menu, point to Database Utilities, and then click Compact and Repair database. Note that after the database is finished compacting, the date and the time in the Created and the Modified columns have been updated to the system date and time.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbbug kbpending KB244642
©2004 Microsoft Corporation. All rights reserved.