You search an entire database the same way you would search one table, by changing the table name in your select statement.<BR><BR>If the connection is still open, you can use the open connection, otherwise open a new one. It all depends on how you've done your programming.
Yes you can. You'll get all the results in one recordset. <BR><BR>When you're selecting multiple tables in one select statement, you need to qualify the column names with the table name. otherwise, if two tables have similar column names, the provider will get confused.