Evening All,
I've got a connection to a mySQL database set up using myODBC. The connection opens as does the recordset. I begin a new transaction and tell the recordset to create a new record. It writes the first two fields (one is defined as date field, the other a time field) but when it comes to the third which is a varchar(255) field, it crashes out with a 'Multiple Step Operation Generated Erros - check each status value."

So when you query conn.errors.count, there is only 1 error - this is 3625. 3625 basically says that it can't find the object in the requested collection. I've been back on the mySQL server and double checked the stupid thinks like spelling. I've even dropped the column from the table and then added it back in again to make sure nothing had become corrupt, but still get the error. It appears every time I run the code.

Can any one offer any suggestions?? I'm happy to try anything at this point! Can't seem to find anything similar to this on the net at all....

The line of code which causes the problem is:-

rs.fields("loginfo") = logdetail

Cheers
Richard

hi there..

this may sound stupid..
but try this things..

first of all.. the source for your query must include the field.. is that ok???

another thing you can try, if to pause the code in the line that has the error, so you can check if the recorset really has that field on it...

HTH...

Gonzalo Bianchi

Hi Gonzalo,
Yes the table name is quoted correctly in the code, as is the field name. What I can't understand is that the code must be finding the field, because when you pause the code and place the mouse over the line the 'tip' box appears with rs.fields("loginfo") = Null

So it knows its currently a null field, it just won't accept the string I'm trying to put in it!

Cheers
Richard

then you have another type of error..

try inserting less data..

do a run with f8.. maybe the error is in another line???

try to left the field empty...

HTH...

Gonzalo Bianchi