Hi,

I have Access file. "Table1" in this file include one field: Field1, type string.

I am using VB6 to use Database with ADO that following:


Dim db as new Connection

set db = new connection

db.open "...;Data Source = ...\MyDatabase.mdb"


Dim adoTest as new Recordset


if I use statement, for instance:

adoTest.Open "SELECT * FROM Table1 WHERE Field1 like '*abc*';", db,...

then adoTest hasn't got any record.


(if I use: like 'abc' then i'll receive a recordset included records that has 'abc' in Field1)


Please help me. Thanks in advance.

Looking forward to hearing from you.

Best regards,

Dang Ha Vinh