I am getting a run time error 2147217887 1

[Ngabay]

When i try to insert from a form into a database. I keep on getting a multi step error. What does that mean?

 

[UncleT]

What is the error message you are receiving?

 

[Ngabay]

note that my form is bound to ADO controls.


the error i get is:

Run Time Error" '-2147217887 (80040e21)'
Multi Step operation generated errors. check each status value

thanks

 

[zemp]

It may be because you are trying to add a foreign key value that does not exist in the foreign keys primary table.

But it could be something else. Post your insert statement and information about the tables involved.

I like to use debug.print to see exactly what my sql is and then copy that directly to the database (Query analyzer for SQL server) to see if it works. Sometimes their error handlers return better information than ADO's.

Thanks and Good Luck!

zemp

 

[jel]

I usually get a 'multiple step' - error message when the datatype the database is expecting is not the same as the datatype I try to insert.
For example: "1-05-2003" as a string cannot be put into a date field, etc.