Print Page | Close Window

Data type mismatch in criteria expression

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4043
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Data type mismatch in criteria expression
Posted By: smith_martin
Subject: Data type mismatch in criteria expression
Date Posted: 03 July 2003 at 12:43pm

here's the error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

here's the code:

 Dim strConn ' Database connection string
 Dim SQL  ' String that will have our SQL statments

 ' Time to create and open recordset
 Set RS = Server.CreateObject("ADODB.Recordset")
 RS.CursorLocation = 3 ' adUseClient
 RS.Open SQL, strConn ' adOpenKeyset CursorType

error is reported on that last line of code. Any ideas / help? Thanks.



-------------
--
martin smith
http://students.mwc.edu/~msmit8iu/webdev/index.html



Replies:
Posted By: Bunce
Date Posted: 03 July 2003 at 12:51pm
Depends whats in the variable SQL, which you didn't post.

-------------
There have been many, many posts made throughout the world...
This was one of them.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net