http://www.daniweb.com/forums/thread305436.html


accidentally i posted in the wrong forum.

I have posted to the previous unmoved post -

Your problem lies in your string syntax -

str = "select * from emp where Filename= &key "

Try -

str = "select * from emp where Filename=" & "'" & key & "'", conn, AdOpenStatic, AdLockOptimistic

This should return the values you are looking for.