I'm having a hard time finding out why I'm getting this error. Seems to work
just fine on another site I built. I went to ASPFAQ.com, Microsoft.com, and
some other sites. Have not been able to spot the problem yet.

Very simple code:

First, the connection:
strConnection ="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&server.mappath(".\**.mdb")&";User Id=***;Password=***;"
filePath = Server.MapPath("***.mdb")

Next, the code, which queries one table in an Access database, and pulls a
city, state, name, and phone number, all of which are of type Memo:


<% Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnection
objConnection.Open

strSQL = "select State, City, BranchID, Phone, BranchName from CMMain "

set RS = objConnection.execute (strSQL)
RS.Open strSQL, objConnection,1,1

If Not RS.EOF Then
Do While not rs.EOF
  strState = rs("State")
  strCity = rs("City")
  strBranchID = rs("BranchID")
  strPhone = rs("Phone")
  strBranchName = rs("BranchName")
%>
<tr>
  <td>
  <%=strBranchName%>
  </td>
  <td>
  <%=strCity%>
  </td>
  <td>
  <%=strState%>
  </td>
  <td>
  <%=strPhone%>
  </td>
</tr>
<%Response.Clear()
Loop
End if
set rs = nothing
set ObjConnection = nothing
%>

Got past it.

this was redundant, so I got rid of the second line:

Show quoteHide quote

Reporting ASP
converting rtf to JPEG?
ASP position question
ASP error in pm.asp line 192 (second try - Please help)
Turn Calculated Field Results into Currency