Get Table Information

[Jengo]

Is their any way to get the table names and column names in a table through an SQL statement in Access 2000? I know SQL Server and Oracle both have them (select table_name from user_tables).

 

[scking]

No. You need to write code to accomplish that is Access. Using DAO, ADO, ADOX (Schema), and just searching throught the data containers and set a table object to each table. It's really not very difficult, but you can't use SQL.


----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------