I thank you in advance for helping me out with this.

I suspect my drivers are corrupted.

Error:
Microsoft JET Database Engine error '80040e14' 

Internal OLE Automation error 

/main.asp, line 267 

Info: I've tried using the MS Access driver as well

Code:

	objConn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source="+Server.Mappath("db/Message.mdb")+";" & _ 
           "User Id=;" & _
           "Password="

'some code in between, unrelated to SQL
	strSQL = 	"SELECT * FROM Messages where refnum like '%-" 
+CSTR(MM)+CSTR(DD) + "%'"
	
	
	response.write strSQL 
	objRst2.Open strSQL, objConn2

Weirdness: When I remove the LIKE phrase, it works! 

Don't use + to concatenate strings, as it is an overloaded operator - use &
instead.

Please post the output of your Response.Write(strSQL) statement so that we
can see what you're sending to the database.

Also, what type of field is refnum

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "DD" <dh003756@e...>
Subject: [asp_databases] Microsoft JET Database Engine error '80040e14'


: I thank you in advance for helping me out with this.
:
: I suspect my drivers are corrupted.
:
: Error:
: Microsoft JET Database Engine error '80040e14'
:
: Internal OLE Automation error
:
: /main.asp, line 267
:
: Info: I've tried using the MS Access driver as well
:
: Code:
:
: objConn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
:            "Data Source="+Server.Mappath("db/Message.mdb")+";" & _
:            "User Id=;" & _
:            "Password="
:
: 'some code in between, unrelated to SQL
: strSQL = "SELECT * FROM Messages where refnum like '%-"
: +CSTR(MM)+CSTR(DD) + "%'"
:
:
: response.write strSQL
: objRst2.Open strSQL, objConn2
:
: Weirdness: When I remove the LIKE phrase, it works!

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

Thanks for your reply! :) Sorry for the late reply. Been v busy.

response.write(strsql) (answer in >>><<<<)
>>>SELECT * FROM Messages where refnum like '%-09012%<<<<

+ was changed to &

I think this is a serious ODBC problem. Any advice? I've tried to 
reinstall and upgrade to MDAC 2.6

Note that the strSQL is correct -
>>>>SELECT * FROM Messages where refnum like '%-09012%'<<<<

I doubt its the SQL statement. If I replace like with the "=" phrase, it 
will work fine. this is strange

refnum is type 'text'

It worked perfectly last time, therefore I suspect corruption of drivers. 
Need to fine a solution. I've searched everywhere, to no avail.

If I changed my objConn2.Open to::

objConn2.Open "DBQ=" & Server.Mappath("db/Message.mdb") & ";Driver
{Microsoft Access Driver (*.mdb)};"


My error msg changes slightly::

Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 
[Microsoft][ODBC Microsoft Access Driver] Internal OLE Automation error 

I wonder if anyone will be able to solve this. I think this is err. very 
rare.

THanks in advance!

There is a ' missing at the end of your SQL statement

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "DD" <dh003756@e...>
Subject: [asp_databases] Re: Microsoft JET Database Engine error '80040e14'


: Thanks for your reply! :) Sorry for the late reply. Been v busy.
: 
: response.write(strsql) (answer in >>><<<<)
: >>>SELECT * FROM Messages where refnum like '%-09012%<<<<
: 
: + was changed to &
: 
: I think this is a serious ODBC problem. Any advice? I've tried to 
: reinstall and upgrade to MDAC 2.6

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

Thanks for your reply, Ken, but the "'" has been already added earlier. I 
pasted the corrected version of response.write(strSQL) earlier.

Still hoping to get a solution. Thanks again, in advance...

Did you try to "Compact and Repair" the database?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "DD" <dh003756@e...>
Subject: [asp_databases] Re: Microsoft JET Database Engine error '80040e14'


: Thanks for your reply, Ken, but the "'" has been already added earlier. I
: pasted the corrected version of response.write(strSQL) earlier.
:
: Still hoping to get a solution. Thanks again, in advance...

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