Error on Updating a DB record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just run the DIF (Database Interface Wizard) to create a section to
edit and delete records ina database (I have done this about a dozen times
with no problems!!!!!!!!!!!!!!!!!), however for some reason only known to
FP2003 I am now getting an error message when updating a record: -

Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.

Why is this happening when all my others (on separate sites) work fine?

Tia
 
My guess is that you have no problem adding a new record. Is that right?

Suggestion: Check the "names" of your fields in this troubled database. Is
it possible you have used new names in this troubled database which you have
not used in the others that you have no problems with?
 
I can submit & delete records in the same database table from the pages
created by the wizard but just can't update.

The db is a SQL so I wonder if it's permissions?
 
Back
Top