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

 Last reviewed: March 17, 1998
Article ID: Q155669
The information in this article applies to:
  • Microsoft Access versions 7.0, 97

SYMPTOMS

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

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

You have a newer version of Oleaut32.dll, which may have been installed by Microsoft Internet Explorer version 3.0 or Microsoft Windows NT version 4.0.

RESOLUTION

Type all four digits for the year when you enter a date.

MORE INFORMATION

Microsoft Access 7.0 and 97 both use Oleaut32.dll to determine what century to use for dates when you do not specify the full year. The file can incorrectly calculated the date if it is the file supplied with Microsoft Internet Explorer version 3.0 or Microsoft Windows NT version 4.0.

If you are having the problem mentioned in this article you may be using one of the following files: 

   File/Version              Operating System                      Size
   ----------------------------------------------------------------------
   Oleaut32.dll v2.1         Windows 95 / Windows NT 3.51          227 KB
   Oleaut32.dll v2.20.4049   Windows Explorer 3.0 / Windows NT 4.0 462 KB

Additional query words: Y2K Year 2000 millennium
Keywords : GnlFrmt kbusage kb2000
Version : 7.0 97
Platform : WINDOWS
Hardware : x86
Issue type : kbprb
Solution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 17, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.