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