UC Berkeley Year 2000 Information Departmental and Personal Computers: Find and Resolve Y2K Problems
Home | Overview | Readiness Checklists | Computer Advisories | Software Tools | Specific Issues | Recharge Services | Peer Help | Search | Site Map | UCB Y2K Home

This page was last updated early during the year 2000 and some or all of its content may thus no longer be current or accurate.

PCs Running Windows NT 3.51: Y2K Readiness Checklist

Summary

Hardware Go

Many industry-standard (also known as "Intel-based" or "IBM-compatible") PCs have a minor hardware problem affecting their internal clocks: instead of rolling over normally from 1999 to 2000, these clocks will instead revert to a different year. There are a variety of methods available for finding and resolving this problem.

The Y2K Hardware Problem Affecting Many PCs Go

Windows NT includes integral features which should - to the extent that these features work as described by Microsoft - allow nearly all PCs with Y2K non-compliant hardware to nontheless transition successfully to the year 2000.

Operating System Go Microsoft maintains that Windows NT 3.5.1 - if not patched as indicated below - is known to have at least eight Y2K-related issues.

As of June 16, 1999, Microsoft maintains that Windows NT Workstation 3.51 can be made Y2K compliant with:

  • Windows NT 3.5.1 Service Pack 5;

    and

  • A "Post SP5" hot fix that contains patches for all of the known Y2K compliance issues for Windows NT Version 3.51 Service Pack 5.
Application programs Go Check for Y2K compliance.
Data files & data sharing methods Go Check for Y2K compliance.

1. Hardware

[ ] 1.1. Find and resolve Y2K hardware problems in your PCs running Windows NT 3.51.

Many industry-standard (also known as "Intel-based" or "IBM-compatible") PCs have a hardware problem affecting their internal clocks: instead of rolling over normally from 1999 to 2000, these clocks will instead revert to a different year (such as 1980).

While this is generally of minor concern, an invalid date could nonetheless cause problems for certain application programs. A small fraction of these problems could potentially have serious impacts. As a result, it's preferable to find and resolve this problem before the year 2000 arrives. The Y2K Hardware Problem Affecting Many PCs Go describes how to do so. Here's a summary:

You can identify which PCs will be subject to this problem by checking with vendors or by using manual or automated software tests.

There are at least ten different methods you can use to prevent the problem from occurring on your non-compliant PCs. Among these:
  • Running an operating system, such as Linux and recent versions of Windows NT, that incorporates a date correction feature;
  • Leaving your PCs turned off over the century transition and using a specific procedure to manually set their dates when they are first started up during the year 2000;
  • Installing small software programs that automatically correct the date;
  • "Flash" updating the software in the BIOS chips in your recently-manufactured PCs to make these chips Y2K compliant;
  • Synchronizing your computers' dates over a network;
  • Upgrading PCs with BIOS add-in cards or other hardware.
Each of these methods has its own particular advantages, limitations, and drawbacks, which are described in the above document.

As a fallback, you can manually reset your problematic PCs to the correct date when the year 2000 arrives. After doing so, all (or nearly all) of your PCs should then continue to maintain the correct date throughout the year 2000 and beyond.
Windows NT 3.5.1 may be able to correct for nearly all PC Y2K hardware problems

Windows NT includes integral features which should - to the extent that these features work as described by Microsoft - allow nearly all PCs with Y2K non-compliant hardware to nontheless transition successfully to the year 2000.

Microsoft claims in its white paper, Windows Operating System Interactions with BIOS and Real Time Clock Go that when Windows NT (both versions 3.5.1 and 4.0) boots, it reads the current date from a PC's Real-Time Clock (RTC). If the RTC's date falls within the years 1900 through 1919, NT will add 100 to the year, changing it to the correct year in the range from 2000 to 2019. As described, this mechanism should be able to effectively correct invalid dates even on PCs with non-compliant BIOS chips.

In addition to correcting the date at boot time, NT can also continually correct the date thereafter. An NT "time daemon" runs approximately once an hour, and can "update the operating system time and date to be consistent with the [corrected date from the] RTC" if they are more than one minute apart.

Finally, Microsoft notes that applications can't bypass Windows NT to obtain an (incorrect) date from a PC's hardware. "The Windows NT operating system prohibits applications from directly accessing the RTC/BIOS combination" to obtain the current date and time. All programs which use Microsoft's programming routines (APIs) will obtain the date from the Windows NT operating system, rather than directly from the PC's hardware.

2. Operating system

[ ] 2.1. Check Microsoft's Web site for the latest updates to its Y2K compliance statement for Windows NT 3.51.

Over time, Microsoft has made revisions to its Y2K compliance statements for Windows NT and many other Microsoft operating systems and applications. As a result, it's probably a good idea to schedule one or two checks, later in 1999, to see whether Microsoft might have once again revised its Y2K Product Summary for Windows NT 3.51 Workstation Go.

[ ] 2.2. Install Service Pack 5 for NT 3.51 and the Y2K-fix Hot Fix.

The following instructions were current as of May 1999. If Microsoft should subsequently release a revised Y2K compliance statement for Windows NT 3.51, it's possible that these instructions might be out of date. Be sure to check Microsoft's latest Y2K compliance statement for updates (see section 2.1 above).

Caution! Before installing any updates or patches which may alter your computer's operating system software or application programs, and before making any changes to your critical documents (data files), be sure that you have a complete, current backup of your computer's data.

For general backup advice, see the Berkeley Computing and Communications articles
Ask Dr. Micro: How can I back up the files on my computer Go
and
Simplify your life with the UCBackup service Go.

Microsoft provides Y2K updates for Windows NT 3.51 in the form of the Windows NT 3.51 Service Pack 5 (SP5) and a post-SP5 hot fix (Y2K-fix). You can download both of these at no cost from Microsoft's FTP site, in the following directories:

Microsoft's FTP directory for the Windows NT 3.51 Workstation and Server U.S. Service Pack 5 Go

Microsoft's FTP directory for the Post-SP5 Y2K hot fix Go

There are two executable files provided in this directory. The file y2k351-i.exe is for industry-standard PCs with Intel (and compatible) processors, and thus is the file that most PC users will need to download.

Both of the FTP directories above also include README.TXT files which provide instructions for installing SP5 and the Post-SP5 Y2K hot fix. We recommend that you read these files (and perhaps print them for future reference) before downloading and installing this software.

[ ] 2.3. (Optional, but recommended) Change Microsoft Windows NT's default short date style to display dates with full, four-digit years.

Many personal computer operating systems are set "at the factory" to display dates with two-digit years, such as "05/13/29". These dates are century-ambiguous; they could reasonably be interpreted as falling within either within the 20th or 21st centuries.

It is usually beneficial to change your operating system's "short date style" to display dates using four-digit years, such as "05/13/1929" or "05/13/2029". When you do this, your application programs that use this display format will also start displaying dates with four-digit years. This can help you in three ways:

  • You can now see immediately, when you enter dates with two-digit years, whether your program has assigned these dates to the 20th or 21st century.

  • In some circumstances, this can help prevent dates with century-ambiguous two-digit years from being exported to text files or copied to the Clipboard.

  • With a few application programs, this may enable you to enter a wider range of dates.
For details, see Changing Your Operating System's Default Date Format To Use Four-Digit Years Go .

As a related measure, we also recommend that you follow the practice of entering dates with four-digit years, such as "05/13/1929" or "05/13/2029". For details, see Why You Should Enter Dates With Four-Digit Years Whenever Possible Go .

Here's how to change Windows NT 3.5.1's default short date style to display four-digit years:

  1. Use the International option in the Control Panel to change Windows NT 3.51's default short date style.

  2. In the Date Format box, choose the Change button and check the Century (1990 vs. 90) box.

[ ] 2.4. (Optional) Update the OLE Automation Libraries, if necessary.

A potential problem in Windows 95, NT 3.5.1, and later versions of Microsoft Windows is that certain Windows Service Packs and application programs install different versions of the files associated with the OLE Automation Libraries. These Automation Libraries tell the Windows operating system and many application programs how to interpret century-ambiguous dates with two-digit years, such as "05/13/29", as either May 13, 1929 or May 13, 2029.

As described in The Windows Automation Libraries Determine How Dates Entered With Two-Digit Years Are Handled Go the date-handling behavior of these libraries has changed three times over the years. If you install a program that overwrites your current Automation Libraries files with a different version of these files, the way that Windows and many of your application programs interpret two-digit dates might suddenly change.

Of particular concern, versions of the Automation Libraries prior to 2.20.00.4054 will always interpret two-digit dates from "00" through "99" as falling within the period from "1900" to "1999", which will probably not be desirable when the year 2000 arrives. For this reason, you might want to check to make sure that you're using version 2.20.00.4054 or higher.

Microsoft's White Paper
The Automation Libraries and the Year 2000 Go, describes how to check your version of the OLE Automation Libraries:

Click the Start button, select the Find menu item, and click on "Files or Folders..." In the "Name & Location" tab, type (without quotes) "oleaut32.dll" in the field titled "Named." Select the drive in the "Look in" field that your operating system lives on (usually (C:) ). Click "Find Now." When the file shows up in the box below, right click on the file and select "Properties." Click the right hand tab that says "Version."

3. Application programs

[ ] 3.1. Check custom-written programs for Y2K compliance.

Custom-written (or "customized") application programs have been written "from scratch" or else extensively modified to perform a customized set of tasks for a specific customer. Some campus departments are running such applications, which typically have been created by departmental programmers or outside consultants. Often, these programs were built using programming or scripting languages, database management systems, or client/server tools.

Custom-written programs are at considerable risk for Y2K problems. Some of these programs may not work properly in the year 2000, or may encounter problems when handling dates from the year 2000 and beyond. If one or more of these programs are of significant importance to your campus department, it is essential that you find and resolve their Y2K problems. It is also imperative that you begin your work as early as possible, as the process of identifying, fixing, and testing fixes to custom applications can often be very time consuming.

Custom Applications: Finding & Resolving Y2K Problems Go can direct you to resources to help you find and resolve Y2K problems in custom applications. In particular, you can obtain a great deal of assistance from the Web pages of the UC Berkeley campus's Year 2000 Departmental Customized Applications Subcommittee, which has identified a phase-by-phase process that can guide you in carrying out this work.

[ ] 3.2. Check off-the-shelf application programs for Y2K compliance.

It appears likely that most commercial off-the-shelf application programs will work fine in the year 2000. However, some application programs are known to have Y2K problems or issues, ranging from minor to severe. If some of these application programs are important to your department or to your own research or instructional work, you'll need to resolve their Y2K problems before the year 2000 arrives. To do this, we suggest that you:

4. Data files & data sharing methods

[ ] 4.1. Check data files for Y2K compliance.

Data files, including spreadsheets and database files, can harbor Y2K problems. If some of these files are important to your department, or your personal research or instructional work, you'll need to resolve their date-related problems before the year 2000 arrives.

The Berkeley Computing and Communications article Checking your data for Y2K problems Go provides a overview, and the document Data Files: Finding & Resolving Y2K Problems Go describes in somewhat more detail how to check your data files to find and resolve Y2K problems. The following are some key points mentioned in both of these documents:

The primary areas of Y2K-related concern in data files are:

  • Custom macros, scripts, and user-defined functions.

    Some spreadsheet and database files may incorporate custom-written macros, scripts, or user-defined functions which improperly handle dates.

  • Standard date functions.

    Many spreadsheet and database programs provide standard date-related functions which are known to have Y2K-related "usage issues." Examples include Microsoft Excel's =DATE(), Microsoft Access's =DateSerial(), and Lotus 1-2-3's @YEAR().

  • Dates stored as text or numbers.

    Dates stored in spreadsheet cells or database fields as text (e.g., "02/21/15") or integers (e.g., "990405"), may present risks when these values are converted to dates, or when they are compared or sorted.
In addition, we encourage you to take four specific steps to help keep Y2K problems out of your data files Go in the future.

[ ] 4.2. Check data sharing methods for Y2K compliance.

Data shared between application programs could in some cases present Y2K problems. You can find guidance on finding and resolving these problems in Data Sharing Methods: Finding & Resolving Y2K Problems Go .

Methods of sharing data which are at risk include documents exchanged via disks, e-mail attachments, and file servers; data copied and pasted via the Clipboard; and programmatic data streams between programs.

To find situations where you'll need to check your data sharing methods for potential Y2K problems, ask yourself three questions:

  1. Do you export data containing century-ambiguous dates, such as "05/13/29", from any of your programs?

  2. Do you import data containing century-ambiguous dates into any of your programs?

  3. Do you share any files (such as spreadsheet or database files) containing dates stored as text or numbers, rather than as dates?




Find something unclear? Missing? Incomplete? Inaccurate? Or even praiseworthy? Send us feedback about this Web site!

This site is provided by the campus Year 2000 Departmental Computers and Administrative Equipment Subcommittee at the University of California, Berkeley.

Copyright 1999 by the Regents of the University of California.
Disclaimer: The University assumes no liability if the information on this page is used for other than University purposes.