Hi,

I am using the following code

Set hubsdb = OpenDatabase("", dbDriverComplete, False, "ODBC;DSN=mysqltest;UID=root;PWD=xli2310;Database=adjuster")

Set rs = hubsdb.OpenRecordset("select * FROM personal WHERE general LIKE 'Personal%'", dbOpenDynaset)

MsgBox (rs.RecordCount)

i get zero results back, but when i run the query in the mysql control center, i get 10 results back.

when i change the above sql to "Select * from personal" i get all the items from the table back.

strange?

is there a bug?

thanks

MArk