>I am using views to update a SQL Server table and on one record I get the 'Datetime field overflow' error. Any thoughts as to what causes this?

On that record what's the datetime value? Not one of in the range SQL server can handle (smalldatetime from 1900 to 2079,datetime 1753 to 9999 - no empty values but nulls accepted).
Cetin