A detailed list of Access issues is provided on the FMS Inc. site: http://www.fmsinc.com/tpapers/year2000/index.html
Access 95 and later will interpret a two-digit year differently depending on the version of OLEAUT32.DLL installed on your system. Some versions assume the century is the current system date century; some window 1920-2019; Office 97 windows 1930-2029.
The default Access 2 input mask doesn't recognize any date past 1999. If you use a short date format and input "00", the default goes to 1900. To correct this, goto Design View, click on Input Mask, and type 99/99/9999 or whatever format you want. That _is_ tedious to have to do for every control. You might wish to consult the Microsoft KnowledgeBase PSS ID Number: Q132067 Article last modified on 05-27-1996 PSS database name: ACCESS 2.00 WINDOWS. This article describes two methods that you can use on a field formatted for the Short Date data type so that it displays a year later than 1999.
Microsoft Products that Store or Manipulate Dates Year Limit
Microsoft Access 95 and before (full 4-digit "YYYY" year) 9999
Microsoft Access 95 and before (2-digit "YY" year shorthand) 1999
Microsoft Access 97 ("YY" year) 2029
Visual FoxPro ("YYYY" year) 9999
Q: What are the year limit details for Microsoft database products?
A: Every Microsoft database product including Microsoft Access, Visual FoxPro, and Microsoft SQL Server stores years in 4-digit form. Microsoft provides users with the ability to enter 2-digit short cuts for year data (i.e., "96" instead of "1996"). When a user types in a 2-digit year, Microsoft’s programs actually store the complete 4-digit year – unlike many older mainframe programs, which store just the 2-digit form. There is no standard way in the industry to interpret 2-digit year short cuts and as a result, errors can occur when dates are entered and displayed only using 2-digits. Of course, users of Microsoft products can always type in all 4 digits of a year to clearly identify the date they want to store in order to reduce possible data entry errors.
Microsoft Access 97 interprets "00" to "29" as short cuts for the years "2000" to "2029." Microsoft Access 95, and earlier versions, interpret "00" to "29" to be short cuts for "1900" to "1929."