Hello,

I have an Access database with a field "OUTDATE" ot type date/time.  My 
script 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)
Multiple-step OLE DB operation generated errors. Check each OLE DB status 
value, if available. No work was done.

Please HELP!!!!
Thanks!
---Carlos

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Carlos L LaMar" <clamar@s...>
Subject: [access_asp] updating a date field


: Hello,
:
: I have an Access database with a field "OUTDATE" ot type date/time.  My
: script 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)
: Multiple-step OLE DB operation generated errors. Check each OLE DB status
: value, if available. No work was done.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

www.adopenstatic.com/faq/80040e21.asp

I suggest you validate the value in Request.Form("outdate") before you try
to stick it into your database. At the very least, use isDate() to check
that it can be cast as a valid date/time.

Cheers
Ken

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


Read this ...

Scenario 1 - Error occurs when inserting data
The error will occur at the point when you try to commit data to the 
database. This might be when you execute an SQL string using an ADO 
Connection object's .Execute() method, or when you call a 
Recordset's .Update() method. The error typically looks like:

Microsoft OLE DB Provider for SQL Server (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status 
value, if available. No work was done. 


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

 
Regards,
santhi



> 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 
status 
v> alue, if available. No work was done.

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