Comments Off on Y2K

Although Access 2000 generally interprets 21st century dates with two-digit years correctly, I strongly recommend that you take advantage of the new Use Four-Digit Year Formatting option in Access to avoid all confusion. When you choose this option, Access displays four-digit years in datasheets, forms, and reports. It also converts whatever you type in an expression (such as Criteria in a query) to display four digits.  Choose Options from the Tools menu, and then click the General tab to set this option. I also recommend that you change your Regional Settings in Windows Control Panel to display a four-digit year in the Short Date Style. This will assist your entry and display of year values in other applications — such as Access 97.

Also check out this excellent whitepaper at FMS, Inc.:
Y2K Issues in Microsoft Access