Forum Discussion
OLE DB or ODBC error: type mismatch (exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
Hello, I have a report that has been running just fine for the last few weeks. Nothing has changed about the report. Upon attempting to refresh the data today - it does not work. If gives m...
It just worked !!! Thank you :)
Hi, there,
This happened to me also. But i figured out that if i remove all the relations to the table it will be better to do changes on it.
When I removed the relations and edited the table (without duplicating it and etc.), all the changes were applied without any problems.
I think it is because you have some "strange" values in a column or columns that are in relation to others and from there it reffers to that TYPE MISMATCH.
It worked for me.
Have a nice day!
Pavlin