You should read the following:
----- Original Message -----
From: "Idris Mansoor"
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, July 14, 2000 10:29 AM
Subject: [asp_databases] SQL in Access 98/2000
> I have the following line in my ASP script:
> SELECT * FROM Name WHERE Name like 'an*';
> Which runs fine in RAW access Query mode both in 98 and 2000 versions.
> does not work thru ASP using CreatObject ADODB object and also thru VB
> (with ref to ADO 2.5 Lib).
> Have I missed a ref to somet else?