how can i get all tables names from MS Access Database

[omer kamal]

Dear all,

Is there any way to display all tables names fom .mdb?

like " SELECT allTableNames FROM DataBaseName"

Regards,
Omer Kamal

 

[Douglas J. Steele]

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*") AND ((MSysObjects.Type) In
(1,4,6)))
ORDER BY MSysObjects.Name;