Unhelpful Error Message - "Multiple-step OLE DB operation"

Access 2000 has a maddening habit of giving error messages which can send you in the wrong direction.

If anyone else hits the following:

Run-time error '-2147217887 (80040e21)':

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

... then you might want to see if your problem is anything like mine was. My problem turned out that I was trying to save too big a value (999 in fact) into a Byte field; changing it to Integer solved it in an instant.