When interpreting two-digit dates, Access makes certain assumptions based on the regional settings in Control Panel. You can alter the way Access interprets two-digit dates by changing these settings.

1. Click Start, point to Settings, click Control Panel, and then double-click Regional Options (or Regional Settings).
2. On the Date tab, click the arrows under When a two-digit year is entered, interpret as a year between to set the ending year.

  Notes  

• This feature has a 100-year span. The default span is 1930 to 2029. A program that uses the default option to interpret two-digit years will consider the years between (and including) 30 and 99 to be preceded by 19, and years between (and including) 00 and 29 to be preceded by 20. For example, 99 will be interpreted as 1999 and 01 will be interpreted as 2001.
• Four-digit years are not affected by this option.