I have a table ("part") in Access 97 database which have two field "id" and "info".

I use ADO connect to the database by following code:
Code:
dim Db as New Adodb.Connection

Db.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & db_path & "\part.mdb"
Db.Open
then I use the following query;

Code:
dim rs as adodb.recordset
set rs = db.execte("select * from part where info like 'M*'")
However, the recordset don't have data but the table have two record which value = "Mother", "Man". So it should return two recrod!?

I don't know what problem it is, but I have test the query in access and it is work!

So please tell me why if anyone have solution, Thank!