SQL to get a list of tables in the database

[Dom]

Dear Newsgroup,

Is there a way to write a query that returns all the
tables in an Access database?

Thanks,

Dom

 

[Lynn Trapp]

SELECT Name
FROM MSysObjects
WHERE Type = 1
AND Name NOT LIKE "Msys*";