Please check my VB/MS ACCESS code syntax

Hi:

When I run the MySQL query below (without the ADO part) from inside a session of MS ACCESS it works fine and returns what I want. But when I embed the following code in a VB pgm the Recordset returns nothing. I know I must be doing something dumb ..... Help

Thanks, Lindsay



MySQL = " Select docrequested, Count(docrequested) " & _
" from WebLogData where docRequested like '*.psd*' " & _
" group by docrequested having Count(docrequested) > 0 " & _
" order by Count(docrequested) desc "

objRSet.Open MySQL, objConn, adOpenKeyset, adLockOptimistic, adCmdText
Do While Not objRSet.EOF
frmDisplayOutput.list2.AddItem objRSet("docRequested")
objRSet.MoveNext
Loop

Hi,

Could you try:

... '%.psd%'...

Regards,
Shurik.

Thanks so much .... It always turns out to be something dumb. I know that the entire SQL world uses '%' but inside MS ACCESS it wanted '*'.

How come it wants '%' when it comes from VB but '*' from inside ACCESS?

Thanks,

Lindsay

Because ADO requires %

maybe it's the ansi thing