Microsoft KB Archive/231408

= ACC2: Access 2.0 Two-Digit Date Update Available in Download Center =

Article ID: 231408

Article Last Modified on 7/18/2007

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q231408



SUMMARY
The Acc2Date.exe file contains an update for Microsoft Access 2.0 that changes the way Access 2.0 interprets dates with a two-digit year.

NOTE: The Acc2Date.exe file was updated on December 17, 1999. This update resolves errors when running certain queries against linked SQL Server tables. For a complete history of the Acc2Date.exe file, see the "Release History" section at the end of this article.

Download Acc2Date.exe now

is available for download from the Microsoft Download Center. It contains the following files:   File name     Version      Description MSABC200.DLL 2.03         The Updated Access Basic file MSAJT200.DLL 2.50.2825    The Updated Access Jet Engine file MSAJU200.DLL 2.50.2819    The Updated Access Jet Utilities file Readme.txt   n/a          A Readme file containing installation information and the End User Licensing Agreement 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 applying the updated files, Access 2.0 will treat two-digit years that the user enters based on a 100 year sliding date range and two-digit years that are imported from text based on a fixed date range.

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/Search.aspx

and then click How to use the Microsoft Download Center

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. Also, in the following steps, is a generic term that refers to the folder where you have Windows installed. For example, if you are running Windows NT 4.0, the default folder is \WINNT. If you are running Windows 95/98 or Windows 2000, the default folder is \Windows.  Download the Acc2Date.exe file to any folder on your hard disk. Search for the Msabc200.dll file on your hard disk and rename the file to Msabc200.old. The Msabc200.dll file is typically located in the \System folder. Search for the Msajt200.dll file on your hard disk and rename the file to Msajt200.old. The Msajt200.dll file is typically located iin the \System folder. Search for the Msaju200.dll file 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 \System folder. It is important that you rename all copies of the file for this update to work. 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. Copy the Msabc200.dll file from C:\Accupd to the \System folder. Copy the Msajt200.dll file from C:\Accupd to the \System folder.</li> Copy the Msaju200.dll file from C:\Accupd to the Access 2.0 application folder. By default this is C:\Access, but it may be different on your computer.</li> Open the \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.</li> 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.</li> Save the changes, and then close the Win.ini file.</li> After the updated files are installed on your computer, back up and compact your Access 2.0 databases.</li></ol>

The next time that you run Access 2.0, the interpretation of dates will be changed.

For additional information about the specific problems that this update fixes, click the article numbers below to view the articles in the Microsoft Knowledge Base:

75455 ACC2: Years Between 00 and 29 Are Interpreted as 1900 to 1929

230593 ACC2: All Two-Digit Dates Imported from Text Resolved in 1900s

245549 ACC2: Error Message Running Query After Installing the Access 2.0 Two-Digit Date Update

Release History
The Access 2.0 Date Update has been released four times prior to the current release. Below are the dates and the details of the files included in each version of the release.

Version 4

Released December 10, 1999

<pre class="fixed_text">  File name     Version MSABC200.DLL 2.03 MSAJT200.DLL 2.50.2823 MSAJU200.DLL 2.50.2819 Readme.txt   n/a This update fixed a problem that caused the size of a database to increase significantly after the installation of previous versions of the update.

Version 3

Released November 8, 1999

<pre class="fixed_text">   File name     Version MSABC200.DLL 2.03 MSAJT200.DLL 2.50.2821 MSAJU200.DLL 2.50.2819 This update fixed a problem that caused an error when running a query that used a date as criteria against a linked SQL Server table.

Version 2

Released September 30, 1999

<pre class="fixed_text">   File name     Version ---   MSABC200.DLL  2.02 MSAJT200.DLL 2.50.2819 MSAJU200.DLL 2.50.2819 This update added a 100 year sliding date window as described in the installation steps above.

Version 1

Released May 7, 1999

<pre class="fixed_text">  File name     Version ---  MSABC200.DLL  2.01 MSAJT200.DLL 2.50.2819

Additional query words: 2-digit Y2K update KB2000 Acc2Date exe

Keywords: kbdownload kbfile kbgraphxlinkcritical kbhowto KB231408

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.