Text List of Tables

[Lee King]

I have an Access db containing about 250 tables. I need to create a
text file that lists the names of all of the tables. What is the
easiest way to create such a list?

Thanks

 

[Kevin3NF]

I just kinda hacked at this and it works in mine as a base query:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like 'MSys*') AND ((MSysObjects.Type)=1));

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

 

[Lee King]

I just kinda hacked at this and it works in mine as a base query:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like 'MSys*') AND ((MSysObjects.Type)=1));

Thanks Kevin. That's just what I needed.

Lee