I want to take information from one database and save it in another database. how can i change the direction of the data adapters? I have also tried to define new data adapters in the same way as the others but with the connection string fixed to the target database, but this make nothing.
The structure of the tables in both database is the same, the target database is only a subset of the another one
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!
OK!!! I am close to the solution. The problem was that the RowState property stay as Unchanged,becouse of that the Update command made nothing. The next question ist: How can i change manuallity this "onlyRead" property ?
Does anyone know anything now ?????