Editing Table Records Using ADO

[JonnyCab]

What is the best way to edit table records. ie edit only, no add or delete.

I have a table containing all records with an error in the resource code field of the record. All I want to be able to do is to allow the user to choose a valid resource code for each incorrect record?

Any ideas on how this can best be acheived?

Cheers

Jonny

[Bigley]

Sql statement -

Update tblSomething......Set ResourceCode = 'Whatever' ....Where....

Something like that