Hi all,

I am connecting to tables on SQL Server 7 through remote views. The problem I am having is with dates, they default to 1/1/1900.
So after I add a record this appears, ideally I want this to be blank(that same as a foxpro table) if there is no users input.

Can anyone give me advice on solving this problem, is there something I can change in the server???

Cheers
Mark