Microsoft KB Archive/243005

= ACC2: Access Defaults to Year 100 When You Enter Only the Month and the Day =

Article ID: 243005

Article Last Modified on 11/6/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



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.

Additional query words: pra Acc2Date exe

Keywords: kbbug kbnofix KB243005

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.