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

ID: Q231408

The information in this article applies to:

Microsoft Access 2.0

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.

Acc2Date.exe

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.asp

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.

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 Windows\System folder (C:\Windows\System).

Search for the Msajt200.dll file 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).

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 Windows\System folder (C:\Windows\System). 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 Windows\System folder (C:\Windows\System).

Copy the Msajt200.dll file from C:\Accupd to the Windows\System folder (C:\Windows\System).

Copy the Msaju200.dll file from C:\Accupd to the Windows\System folder (C:\Windows\System).

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.

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.

Save the changes, and then close the Win.ini file.

After the updated files are installed on your computer, back up and compact your Access 2.0 databases.

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:

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

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

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

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/year2000/

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


   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


    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


    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


   File name     Version
   -----------------------
   MSABC200.DLL  2.01
   MSAJT200.DLL  2.50.2819

Additional query words: 2-digit Y2K update KB2000

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