Different results in VB6 ADODB & Access 2003 (11.5614.5606).

[google]

I'm using ADODB to connect to an Access database from VB6. I'm running
a query that's returning strange results- the following query returns
different results in VB & Access:

SELECT * FROM Robes WHERE strSize NOT LIKE '*+';

I've also run the following three queries in VB with the record count
indicated beneath. Access seems to handle the queries fine, but VB
seems to be having problems with the WHERE clause.

SELECT * FROM Students WHERE strSize NOT LIKE '*+';
10321
SELECT * FROM Students WHERE strSize LIKE '*+';
0
SELECT * FROM Students
20118

Thanks in advance for any help you're able to provide.

[google]

Let me add the connection string and code I'm using to pass the SQL to
Access:

Set cnnMain = New ADODB.Connectio n
cnnMain.Open "DSN=MS Access Database;DBQ=" & DB_File & ";DefaultDi r=" &
DB_Path & ";DriverId=25;F IL=MS
Access;MaxBuffe rSize=2048;Page Timeout=5;UID=a dmin;"

Set rsMain = New ADODB.Recordset
rsMain.ActiveCo nnection = cnnMain
rsMain.CursorLo cation = adUseClient
rsMain.CursorTy pe = adOpenKeyset
rsMain.LockType = adLockOptimisti c
rsMain.Source = strSQLString
rsMain.Open

[Lyle Fairfield]

The ADO wildcard is "%".

[google]

Thank you. I do so love it when it's an easy answer.