Hi Viv, thanks for your reply.

I'd appreciate any pointers on how to do this (My first Dot Net App)

Regards,

Gerard


>Hi,
>
>The VFP Oledb provider doesn't currently provide the information required by the OledbCommandBuilder. You'll need to provide the Update,Insert and Delete commands yourself...
>
>Regards,
>Viv
>
>
>>>
>I am trying to create a Data Adapter in a form for VFP using OleDB
>The table is working fine in VFP and I can add records through VFP with a Ctrl N.
>Structure is fairly basic with a few fields, and one Auto Incrementing Field which also has a Primary Key attached, with the Index the same name as the field.
>
>In .net windows forms, when I try to use the wizard to create a Data Adapter,
>It creates the connection OK (Test connection comes back ok)
>
>In the Choose a query type, i chose --> use Sql Statements
>I Select * in options and in advanced options,
>Generate,Insert,Update.delete is ticked
>Use Optimistic Concurrency is ticked
>Refrsh the dataset is greyed out and I cant tick
>
>Then in View Wizard results ,top 3 are ticked but both
>Generate Update Command and
>geberate delete Command say there wer errors configuring the data Adapter anf have yellow icons beside them
>
>Any ideas on whats happening here ?
>>>