Hai
 i too have the similar problem , getting the same error message while 
updating the database from mysql, probably this error is thrown when we 
give the value is longer then the field size. but its not the same with 
me, i declared the field size as 100, but i am unable to give the value of 
20 chars. also,  if i give the value(length) less then existing value its 
ok, but if i try to update the value to the bigger length then existing, i 
cannot do it..! but the same value can be updated if i use  execute 
method. but cannot use with recordset update method.

  can any one please help meee? 

e-mail me to anchoori@i...

regards
Sridhar

> Hi,
 >  Convert the value you r getting from form as date using cdate
o> r else give like this #datevalue#.
 >  Then u may be able to update.

> 
R> ead this ...

> Scenario 1 - Error occurs when inserting data
T> he error will occur at the point when you try to commit data to the 
d> atabase. This might be when you execute an SQL string using an ADO 
C> onnection object's .Execute() method, or when you call a 
R> ecordset's .Update() method. The error typically looks like:

> Microsoft OLE DB Provider for SQL Server (0x80040E21)
M> ultiple-step OLE DB operation generated errors. Check each OLE DB 
status 
v> alue, if available. No work was done. 

> 
T> his error is caused when you try to insert too much data into a 
specified 
f> ield. For example if you enter a string that is 20 characters long into 
a 
f> ield that is defined as varChar(10), or if you try to insert a value 
g> reater than 215 (approx 2.1 billion) into an Integer field.

>  
R> egards,
s> anthi

> 

> > Hello,

> > I have an Access database with a field "OUTDATE" ot type date/time.  
My 
s> > cript attempts to update this field with the entry from a Form:

> > 	rs("outdate")   = Request.Form("outdate")

> > I am getting the following error message:

> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
M> > ultiple-step OLE DB operation generated errors. Check each OLE DB 
s> tatus 
v> > alue, if available. No work was done.

> > Please HELP!!!!
T> > hanks!
-> > --Carlos