My client has a student registration form originally developed in Access 97. Under student info in Access 97 the Date of Birth is: 5/2/98, Date Baptized: 8/20/00.

After upgrading to Access 2002 the Date of Birth now reads: 5/2/1998, Date Baptized: 8/20/1900.

I am not a DBA so how can i correct the incorrect dates in Access 2002 to reflect the real date such as in Date Baptized in the first paragraph above!

All of the records have some sort of date error. 1903, 1901, 1900 etc.

Thanks