Hi Sergey

Thankyou for the info, I am using VFP9, but hadn't updated my profile. I have never used cursor adapters, are their any good tutorials, or can you recomend any books on their use ?

Thanks
Darren


>You can upgrade to VFP9 and use CursorAdapter class with VFP OLE DB
Provider.
>
>>
>>I have added an autoinc field to that table which would be causing the problem. Are their any other options to use in this case, where I will probably want to upsize later ?
>>