>I have some records in my system from our mainframe that have the year as 1900. Does anyone know of a simple way I can:
>
>1. Change the year to 2000

Here you can do an UPDATE table SET date = 2000 where date = 1900
or some permutation of that idea. But that doesn't cure say for example 1932 so you would have to be a little more creative than that.

>2. Code in my pre-processing routine to prevent this from happening..

If your preprocessing routine is written in VFP you have a number of options. One being SET CENTURY w ROLLOVER clause and implementing a strict date format would be another (see Help on Strict Date). There is also a compiler option in the Tools / Options screen to check for problems in your code regarding dates.

HTH