Recent content by Izoel

again, thank you for replying. and yes, I get result from every query, from the simple SELECT to the JOINED SELECT, which why I wonder, why only the LIKE expression didn't work at all.. is there any compatibility problem with .NET? I use VB.NET 2005 with Access 2007, but save the mdb file with...

@pbaldy, thank you for your answer, I have use the %, ?, and * - but still it doesn't work.. any suggestion? could it be something wrong with my PC? should I reinstall the application?

Hi All, I'm trying to use LIKE expression on my VB.NET code. I have tried that with Access Query and got the result. But when I use VB.NET to do the query, the datatable return zero data. here's what I do; ===================================================== dim sSQL as string = "SELECT *...