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

Retired KB Content Disclaimer

View products that this article applies to.

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.

Collapse this imageExpand this image

Download Acc2Date.exe now (http://download.microsoft.com/download/access20/update/1/win98/en-us/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.aspx (http://www.microsoft.com/downloads/Search.aspx)

and then click How to use the Microsoft Download Center

Back to the top

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, <windir> 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 <windir>\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 <windir>\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 <windir>\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 <windir>\System folder.
Copy the Msajt200.dll file from C:\Accupd to the <windir>\System folder.
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.
Open the <windir>\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:

75455 (http://support.microsoft.com/kb/75455/EN-US/ ) ACC2: Years Between 00 and 29 Are Interpreted as 1900 to 1929

230593 (http://support.microsoft.com/kb/230593/EN-US/ ) ACC2: All Two-Digit Dates Imported from Text Resolved in 1900s

245549 (http://support.microsoft.com/kb/245549/EN-US/ ) 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

   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

Back to the top

APPLIES TO

Microsoft Access 2.0 Standard Edition

Back to the top

kbdownload kbfile kbgraphxlinkcritical kbhowto KB231408

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top