HI.
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 ?

regards,
Gerard