Microsoft KB Archive/208339

= ACC2000: Years 00-29 Default to Year 2000 When Typed as M/D/YY =

Article ID: 208339

Article Last Modified on 6/30/2006

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208339



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you type a date in the format M/D/YY where YY is a number from 00 through 29, Microsoft Access defaults to the years 2000 through 2029.



CAUSE
If you are using Microsoft Windows 95 or Microsoft Windows NT version 4.0, Access uses Oleaut32.dll to determine what century to use for dates when you do not specify all four digits. If you are using Microsoft Windows 98 and you do not specify all four digits, Access determines what century to use based on the When a two digit year is entered, interpret as a year between box setting in the Regional Settings tool in Control Panel.



RESOLUTION
When you enter a date, type all four digits of the year. This will ensure that the date will always be calculated the same way, no matter which version of Oleaut32.dll you have, or what the date range is set to in Regional Settings in Control Panel.

Additional query words: Y2K KB2000 Year 2000 millennium prb

Keywords: kbprb KB208339

-

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

© Microsoft Corporation. All rights reserved.