Thanks for the reply.

Yes i am using CursorAdapter for all CRUD.

But i am using SPT for fetching data into VFP cursors in other places. Is there a way to simplify this alone seperately?

>Only if you're using a CursorAdapter

>>I want to use sql ce through oledb provider.
>>Is there a way to use oledb without changing the data access code much?
>>My application currently uses odbc to connect to sql server 2005.