I cannot reproduce this it works fine for me. Please send me the piece of code that causes the error and I will take a look at it.

Jon

>hi jon
>
>main table structure
>
>docdate datetime
>filename char
>
>second table Structure
>
>Docdate varchar
>filename varchar
>
>So in second table when i try to update Table field Insted of Verchar to datetime it is giving me error.
>
>best regards
>Mazahir