Error on Updating a DB record

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
 
G

Guest

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?
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating db... still struggling 2
Record insert/delete anomaly 0
Multiple OLE DB Operation? 3
Can I change the connection time out for MS Access (using OLEDbConnection) ? 8
How to install Provider on server 4
MSDAOSP (MSXML2.DSOControl.2.6) in the server 3
exporting from sql query results to a excel workbook 2
Edit record gets error 2

Top