I am trying to link asp.net with access (something I hate to do). I am trying to run the following query from vb:
SELECT firstName, lastName FROM people WHERE lastName LIKE 'K*'
when I run it in my DB directly, it works, but when I run it through the code, nothing gets returned. The connection to the DB works just fine otherwise. Any ideas?? I have a question open in the Access section too. Any answers will get credit for both.