>I am using ADO to connect to FoxPro databases / table
>
>I am using date fields.
>
>When I append a record, with a date field in it.
>I need to fill it with "01/01/1900" otherwise I recieve an error.
>
>The tables are also used by a old Dos FoxPro Program.
>This program triggers records with date value " / / "
>
>Now i have i problem
>
>Can someone help me.
>
>Kind Regards
>
>Jan Dorresteijn
Jan,
if the recordset is read-write you can use oRecordSet.fields('yourfield').value = {01/01/1900}, then call the Update method
HTH
Pete Kane
Regards,
Peter J. Kane
Pete