query for ms access

Question

hi.my query is "SELECT column_name, table_name FROM information_schema.columns" .but it execute true in sqlserver ,but it dosn't execute true in Ms Access.i want to get all colums and tables'name from specific database.thanks.

Answer 1

Look to this question: http://stackoverflow.com/questions/698839/how-to-extract-the-schema-of-an-access-mdb-database