======================================================================= Acc2Date.exe Readme File September 30, 1999 ======================================================================= ----------------------------------------------------------------------- | | |This software, including any accompanying documentation (the | |"Software"), is provided to you at no additional charge. Microsoft | |Corporation owns all rights, title, and interest in and to the | |Software. The user assumes the entire risk as to the accuracy and | |the use of the Software. | | | |COPYRIGHT NOTICE. Copyright (C) 1999 Microsoft Corporation. Microsoft| |and/or its suppliers, One Microsoft Way, Redmond, Washington | |98052-6399 U.S.A. All rights reserved. | | | |TRADEMARKS. Microsoft, Windows, Windows NT, MSN, The Microsoft | |Network and/or other Microsoft products referenced herein are either | |trademarks or registered trademarks of Microsoft. Other product and | |company names mentioned herein may be the trademarks of their | |respective owners. | | | |The names of companies, products, people, characters and/or data | |mentioned herein are fictitious and are in no way intended to | |represent any real individual, company, product or event, unless | |otherwise noted. | | | |NO WARRANTY. THE SOFTWARE IS PROVIDED "AS-IS," WITHOUT WARRANTY OF | |ANY KIND, AND ANY USE OF THIS SOFTWARE PRODUCT IS AT YOUR OWN RISK. | |TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND ITS | |SUPPLIERS DISCLAIM ALL WARRANTIES AND CONDITIONS, EITHER EXPRESS OR | |IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES AND | |CONDITIONS OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR | |PURPOSE, TITLE, AND NON-INFRINGEMENT, WITH REGARD TO THE SOFTWARE. | | | |LIMITATION OF LIABILITY. TO THE MAXIMUM EXTENT PERMITTED BY | |APPLICABLE LAW, IN NO EVENT SHALL MICROSOFT OR ITS SUPPLIERS BE | |LIABLE FOR ANY SPECIAL, INCIDENTAL, INDIRECT, OR CONSEQUENTIAL | |DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS | |OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS | |INFORMATION, OR ANY OTHER PECUNIARY LOSS) ARISING OUT OF THE USE OF | |OR INABILITY TO USE THE SOFTWARE, EVEN IF MICROSOFT HAS BEEN ADVISED | |OF THE POSSIBILITY OF SUCH DAMAGES. BECAUSE SOME STATES AND | |JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY | |FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT| |APPLY. MICROSOFT'S ENTIRE LIABILITY AND YOUR EXCLUSIVE REMEDY UNDER | |THIS EULA SHALL NOT EXCEED FIVE DOLLARS (US$5.00). | | | |The following conditions also apply to your use of the Software: | | | |The Software may be copied and distributed internally only, subject | |to the following conditions: All text must be copied without | |modification and all pages must be included; If software is included,| |all files on the disk(s) |must be copied without modification [the | |MS-DOS(R) utility diskcopy is appropriate for this purpose]; All | |components of this Software must be distributed together; and This | |Software may not be distributed to any third party. | | | |If you are not a Microsoft Premier customer, Microsoft shall not | |provide technical support for this Software. | | | |The Software is provided with RESTRICTED RIGHTS. Use, duplication, | |or disclosure by the Government is subject to restrictions set forth | |in subparagraph (c)(1)(ii) of the Rights in Technical Data and | |Computer Software clause at DFARS 252.227-7013 or subparagraphs | |(c)(1) and (2) of the Commercial Computer Software-Restricted Rights | |at 48 CFR 52.227-19, as applicable. Manufacturer is Microsoft | |Corporation, One Microsoft Way, Redmond, WA 98052-6399. Any | |transfer of the Software must be accompanied by this statement and | |may only be transferred if first approved by Microsoft. | | | |You agree that you will not export or re-export the Software to any | |country, person, entity or end user subject to U.S.A. export | |restrictions, and you are responsible for complying with all | |applicable U.S. and local export laws in connection with the use of | |this Software. You warrant and represent that neither the U.S.A. | |Bureau of Export Administration nor any other federal agency has | |suspended, revoked or denied you export privileges. | | | |This EULA is governed by the laws of the State of Washington, U.S.A. | | | ----------------------------------------------------------------------- Introduction ------------ The Acc2Date.exe file contains three updated files that modify the way Microsoft Access 2.0 interprets two-digit years. By default, Access 2.0 interprets all dates that are entered by the user or imported from a text file to fall within the 1900s. After you apply the updated files, Access 2.0 will treat two-digit dates that are imported from text in the following manner: 00 to 29 - resolve to the years 2000 to 2029 30 to 99 - resolve to the years 1930 to 1999 Years that are entered into object property sheets, the query design grid, or expressions in Access modules will be interpreted based on a 100-year sliding date window as defined in the Win.ini on the computer that is running Access 2.0. The Acc2Date.exe file contains the following files: File name Version Description --------------------------------------------------------------------- MSABC200.DLL 2.02 The Updated Access Basic file MSAJT200.DLL 2.50.2819 The Updated Access Jet Engine Library file MSAJU200.DLL 2.50.2819 The Updated Access Jet Utilities file Readme.txt n/a This readme file For more information about the specific issues solved by this update, see the following article in the Microsoft Knowledge Base: Article ID: Q75455 Title : ACC2: Years between 00 and 29 Are Interpreted as 1900 to 1929 Article ID: Q230593 Title : ACC2: Two-Digit Dates Not Interpreted Correctly Importing from Text File Installation ------------ NOTE: Because there are several versions of Windows, the following steps may be different on your computer. If they are, please consult your product documentation to complete these steps. 1. Download the Acc2Date.exe file to any folder on your hard disk. 2. Search for the file, MSABC200.DLL, on your hard disk and rename the file to MSABC200.OLD. The MSABC200.DLL file is typically located in the Windows System folder (C:\Windows\System). 3. Search for the file, MSAJT200.DLL, on your hard disk and rename the file to MSAJT200.OLD. The MSAJT200.DLL file is typically located in the Windows System folder (C:\Windows\System). 4. Search for the file, MSAJU200.DLL, on your hard disk and rename the file to MSAJU200.OLD. The MSAJU200.DLL file is typically located in the folder where Access 2.0 is installed (C:\Access). IMPORTANT: You may have more than one copy of the MSAJU200.DLL file on your computer. For example, if you have installed the Access 2.0 Service Pack, you will have a second copy of MSAJU200.DLL in the Windows System folder (C:\Windows\System). It is important that you rename all copies of the file for this update to work. 5. Run the downloaded file, ACC2DATE.EXE, by double-clicking the file in Windows Explorer or in File Manager. By default, the program will expand the files into the C:\ACCUPD folder on your hard disk. If the folder doesn't exist, it will be created automatically. If you decide to change the folder, remember the folder name where you expanded the files. 6. Copy the MSABC200.DLL file from C:\ACCUPD to the Windows System folder (C:\Windows\System). 7. Copy the MSAJT200.DLL file from C:\ACCUPD to the Windows System folder (C:\Windows\System). 8. Copy the MSAJU200.DLL file from C:\ACCUPD to the Windows System folder (C:\Windows\System). 9. Open the C:\Windows\Win.ini file in any text editor, such as Notepad. NOTE: If you did not install Windows to the default folder, replace C:\Windows with the folder that you did install Windows into. 10. Scroll down to the end of the Win.ini file, and then type the following lines at the end of the Win.ini file: [Microsoft Access 2.0] TwoDigitYearMax=2029 IMPORTANT: If you do not set the value for the sliding date window, Access 2.0 will assume that the two-digit years fall within the 1900s. 11. Save the changes, and then close the Win.ini file. The next time that you run Access 2.0, the interpretation of dates will be changed.