Access Problem

Results 1 to 2 of 2

Thread: Access Problem

  1. #1
    Join Date
    Dec 1969

    Default Access Problem

    On a windows 200 professional machine I have an ASP page interogating an Access Database. On an execute of the following:<BR>"oRs.Open sqlstmt, oConn, adOpenForwardOnly, adLockBatchOptimistic" I am getting a type mismatch error 80020005. oRs is declared as Dim oRs and sqlstmt is Dim sqlstmt which contains a string.<BR><BR><BR><BR>Any ideas why we are getting this error

  2. #2
    J. Paul Schmidt Guest

    Default RE: Access Problem

    Maybe there&#039;s a problem with the SQL statement contained in your variable sqlstmt.<BR><BR>You may want to Response.Write the sqlstmt variable.<BR><BR>Best regards,<BR>-Paul<BR><BR>J. Paul Schmidt, MBA<BR>Databases on the Web<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts