Is There A Solution?

[SAMS]

Hi guys, I got two table in the same database. My problem is my first table(AR) contain all the general records while the other table(AP) whole some of the changes of (AR).

Is there a way to overwrite those records from table (AR) with those that are in (AP) similiar records??

Let's say table (AR) has 500 records (AP) has 5 records that can be found in (AR) but some of the fields figure are different only.

How do i go about telling the program to find thoes similiar records in (AR) with thoes in (AP)??

I tried this :
With Adodc1
.Recordset.MoveFirst
While (Not .Recordset.EOF)
.Recordset.UpdateBatch
.Recordset!gst = Text1.Text
.Recordset.Update
.Recordset.MoveNext
Wend
End With

I don't know why, sometime it works but sometime i got this error message:

"The specific rows could not be located for updating. Some values might have been changed since it was last read."

Pls give your suggestion.Thks a Lot.


[This message has been edited by SAMS (edited 10-12-1999).]

[Clunietp]

An SQL 'update' command may make your life easier and your app more efficient

Update Mytable set myfield = newvalue where condition = value

(or something like that....)