How can I select a filed from different tables in MSAcess database with ASP?

I have a Microsoft Access Database with "n" tables with different names%26amp; all of this tables have "name" filed (column). How can I make a ASP code that select "name" for all of that tables? What is the code?


I write this but it doesn't work, please help me:





rs.open "Select * From *", cn

How can I select a filed from different tables in MSAcess database with ASP?
Use the 'Query Analyzer' in Acess to select each field from each table then go to SQL view to copy and paste the SQL code you need.