ACC2000: Created and Modified Dates for Objects Suddenly Reset

ID: Q244642

The information in this article applies to:

Microsoft Access 2000

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 this to be a problem in Microsoft Access 2000.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.

On the View menu, click Details.

In the Database window, click Forms under Objects. Note the date and the time in the Created and the Modified columns.

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.

Additional query words: pra

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