ACC2: Access 2.0 Two-Digit Date Patch Temporarily Unavailable

ID: Q231408

The information in this article applies to:

Microsoft Access 2.0

SUMMARY

The Microsoft Access 2.0 Date Patch is temporarily unavailable for download due to a problem with how four-digit dates are interpreted under certain conditions. The patch will be made available again as soon as these issues are resolved.

MORE INFORMATION

After installing the files from the Access 2.0 Date patch, you may notice that four-digit dates between the years 1900 and 1929 are converted to the years between 2000 and 2029 when used in the following places.

In the Control Source property
In the Default Value property
In a Validation Rule
As Criteria in queries

There is no way to modify this behavior in the first three cases, but it is possible to workaround this behavior when dates are used as criteria in queries.

Using four-digit dates in queries

The behavior described above will happen when a four-digit date is used as the criteria in a query under the following circumstances.

When you specify the date criteria in the query design grid and save the query.
When you specify the date criteria in the query design grid and move to a different column
When you type a SQL Statement directly into the SQL view, and then change to the query design grid and save the query.

This behavior does not occur when you type a SQL statement directly into the SQL View window and save from that window. After it is saved, you will still see the four-digit date change if you switch between SQL View and query design grid; however, the query will contain the correct date as long as it is not saved while the query design grid is the active view.

Additional query words: 2-digit Y2K update


Keywords          : kbfile kbdta Softlib 
Version           : WINDOWS:2.0
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: August 8, 1999