PDA

Click to See Complete Forum and Search --> : How to get the tables in a database in Access

JetDeveloper
March 1st, 2005, 12:35 PM
In SQL Server, you can use
SELECT * FROM Information_Schema.tables
to get all the tables in a database.

How would I do the same thing using a query in Access?

Thanks in advance
erickwidya
March 1st, 2005, 08:31 PM
check this link (http://www.codeguru.com/forum/showthread.php?p=1099230#post1099230)