ACC2000: Created and Modified Dates for Objects Suddenly Reset

View products that this article applies to.

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

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

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.