Accessing Multiple Tables using vb, ado, sql to a MS Access database


I am trying to search multiple tables in an access database using ado and a sql string. The idea is for it to take selected text out of lstTables.txt and search those tables selected and place the results in lstSearch. How can I make vb open each table one by one, search for strQuery ( in sql command this is the Where EmailAddress='" + strQuery + "'" ) and return which table it found it in to lstSearch.additem? Or if there is another way without using join statements because new tables can be added.. please let me know
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!