Thanks that fixed that error. Now I get a different error.
1435 - "Microsoft SQL Server Compact OLE DB Provider : The given type name was unrecognized. [,,,,,]"

Any ideas on that one?

    This.DataSource = this.oRS
    this.oCommand = CREATEOBJECT("ADODB.COMMAND")
    This.UpdateCmdDataSource = this.oCommand
    This.oRS.ActiveConnection = this.oConn
    this.oCommand.ActiveConnection = this.oConn 

>
>
>

>Check UpdateCmdDataSource in help:
>
>"ADO"  UpdateCmdDataSource must be set to a valid ADO Command object.
>       The ActiveConnection property of the ADO Command object must be set to a valid and open ADO Connection object.
>
>       Visual FoxPro sets the CommandText property of the ADO Command object to the value of the CursorAdapter UpdateCmd property.
>       Visual FoxPro parses the command for  parameters, creates parameter values if found, and sets them in the Command object.
>
>       The update operation occurs as:
>       CursorAdapter.UpdateCmdDataSource.Execute()
>
>      For more information about using an ADO RecordSet, automatic updating, and generating SQL commands automatically, see Data Access Management Using CursorAdapters
>