I am trying to search all available tables in a DB for a specific string. But since I don&#039;t know what the table names are unless I grab them and store them in array. I was thinking that I could mix a little ADOX and ADO and grab the information dynamically but I can&#039;t figure out how to make the SQL line dynamic. Here is my code:<BR><BR>&#060;%<BR> dim DbPath<BR> dim DbConn<BR> dim objTableRS<BR> dim DataConn<BR> dim DataCmd<BR> dim datapath<BR> dim rstable<BR> dim SQL<BR><BR> DbPath = "d:httpmstest .mdb"<BR> Set DbConn=Server.CreateObject("ADODB.Connection")<BR> DbConn.ConnectionString="DRIVER={Microsoft Access Driver (*.Mdb)};DBQ=" & DbPath & ";"<BR> DbConn.Open<BR><BR> Set DataConn = Server.CreateObject("ADODB.Connection")<BR> DataPath = "DBQ=d:httpmstest .mdb"<BR> DataConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DataPath<BR> Set DataCmd = server.CreateObject("ADODB.Command")<BR> Set DataCmd.ActiveConnection = DataConn<BR><BR><BR> Set objTableRS = DbConn.OpenSchema(20, Array(Empty, Empty, Empty, "TABLE"))<BR><BR> objTableRS.MoveFirst<BR><BR> While not objTableRS.EOF<BR> Response.Write objTableRS("Table_Name").Value & "<BR>"<BR> objTableRS.MoveNext<BR> Wend<BR><BR><BR> SQL = "SELECT netid, dategiven FROM [Auditor Training] WHERE netid=&#039;AJ&#039; UNION SELECT netid, dategiven FROM [Infrastructure Training] WHERE netid=&#039;AJ&#039;"<BR> dataCmd.CommandText = SQL<BR> Set rstable = server.CreateObject("ADODB.Recordset")<BR> rstable.Open datacmd, , 2, 3<BR><BR><BR> while not rstable.EOF<BR> Response.write rstable("netid") & "&nbsp; " & rstable("dategiven") & "&#060;/br&#062;"<BR> rstable.MoveNext<BR> Wend<BR><BR>%&#062;<BR><BR><BR>What I was thinking was to encorporate the While...Wend loop into the SQL line but I don&#039;t know how to accomplish that without breaking the sql line. Any suggestions? Thanks in advance.<BR><BR>