ADO Error message

[jagadeeshrp]

Hi,
If anyone have idea on the error messages -2147217887(Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.), 80040e21(Description: Multiple-step operation generated errors. Check each status value.) kindly let me know the details of them to my mail-id: jagadeeshrp@hotmail.com.

Thanks in advance,
Jagadeesh.

[erickwidya]

debug the prog and post at what line of code the error caught..

maybe u want to display a NULL value that u read from a table..if that's the case..
try this code when u do something like that

txt1.text = rs("field1") & vbnullstring


hope it help

PS : hm..i suggest u not display ur email 'open' like that..it sound like an 'invitation' for spam

[Krzemo]

Or u have wrong number of "?" in prepared SQL :rolleyes: .... etc... etc...

Best regards,
Krzemo.

[omiyage]

Maybe you are trying to save data to a database and you were not able to supply all data whose equivalent field in your database does not accept null value.

Example:

STUDENT.mdb
age field is desinged not to accept NULL value or input

You then tried to add a new student record and age is missing. this will cause the error you presented.

SOLUTION:
Make sure you supplied all values for fields designed not to accept NULL values.