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

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 the file Oleaut32.dll, which may have been installed by Microsoft Internet Explorer version 3.0 or Microsoft Windows NT version 4.0.

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, no matter which version of Oleaut32.dll you have.

MORE INFORMATION

Both Microsoft Access 7.0 and 97 use Oleaut32.dll to determine what century to use for dates when you do not specify all four digits. If the file is the version supplied with Microsoft Internet Explorer version 3.0 or Microsoft Windows NT version 4.0, the date can be calculated incorrectly.

If you are having the problem mentioned in this article, you may be using one of the following versions of the file Oleaut32.dll:


   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          : kb2000 GnlFrmt 
Version           : 7.0 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 13, 1999