You are currently offline, waiting for your internet to reconnect

FIX: Error "Wrong Number of Arguments or Invalid Property Assignment: 'Item'" When You Set Field Value in ASP Using ADO 2.5

Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
When you try to update a field in an ADO recordset in Microsoft Active Server Pages (ASP), the following error may occur on a line that assigns a value to a field:
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'Item'
This error occurs when you use the following syntax to assign a value to a field:
rs.Fields.Item("LName") = "Smith"				
This syntax does not specify the Value property, which is the default property. Although it not necessary to specify the Value property in ADO 2.1 and earlier, the absence of the Value property in ADO 2.5 causes the above-mentioned error message.
To resolve this problem, download Microsoft Data Access Components (MDAC) version 2.6 or later. You can obtain the latest version of MDAC from the following Microsoft Web site:To work around this problem, use one of the following methods:
  • Specify the Value property explicitly, for example:
    rs.Fields.item("LName").value = "Smith" 					
  • Avoid using the Item object, for example:
    rs.Fields("Lname") = "Smith"					
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in MDAC 2.6 or later.

Article ID: 305463 - Last Review: 06/19/2014 13:21:00 - Revision: 3.0

  • kbbug kbfix KB305463