I have directory's full of Microsoft Access tables. I have created a form, and put in a drive list box, file list box, and directory list box, and a text box. the user selects a directory, enters a value in the text box, and then I want to search the Access databases for the value, and display the table name where it's located. How do I loop through opening each table, and doing this query?