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:
then I use the following query;Code:dim Db as New Adodb.Connection Db.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & db_path & "\part.mdb" Db.Open
However, the recordset don't have data but the table have two record which value = "Mother", "Man". So it should return two recrod!?Code:dim rs as adodb.recordset set rs = db.execte("select * from part where info like 'M*'")
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!




Reply With Quote