ACC2: Access Defaults to Year 100 When You Enter Only the Month and the Day (243005)


The information in this article applies to:

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

SYMPTOMS

When you enter a date without the year portion of the date (for example, mm/dd instead of mm/dd/yy), Microsoft Access 2.0 stores the date as occurring in the year 100.

RESOLUTION

Install the Acc2Date.exe update for Microsoft Access 2.0. To obtain this update, see:

231408 ACC2: Access 2.0 Two-Digit Date Update Available in Download Center

STATUS

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

MORE INFORMATION

For dates that are greater than 01/01/2000, you must enter the year portion of the date as a four-digit number (9/30/2000). If you enter the date as 9/30, Access again defaults to the year 100.

This problem became evident after computers rolled system clocks to the year 2000. Once a computer's clock was equal to or greater than January 1, 2000, the problem appeared in Access 2.0.

Steps to Reproduce Behavior

  1. In Access 2.0, open the sample database Nwind.mdb.
  2. Open the Orders table in Design view.
  3. Change the Format property of the Order Date field from Medium Date to mm/dd/yyyy.
  4. Save the change and open the table in Datasheet view.
  5. On the first record, change the Order Date to 05/10.
  6. Move the focus from the field and note that the value stored is 05/10/100.
Modification Type:MajorLast Reviewed:11/6/2000
Keywords:kbbug KB243005
©2002 Microsoft Corporation. All rights reserved.