ACC2: Access 2.0 Two-Digit Date Patch Temporarily Unavailable |
The information in this article applies to:
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
