List of the tables

How can I print a list of the tables in my data base?

You can use SQL in a query like:
SELECT msysobjects.Name, msysobjects.Type
FROM msysobjects
WHERE Type IN (1,6);
Keep in mind that this will display system tables and may miss some ODBC
table (not sure).

--
Duane Hookom
MS Access MVP


"Benn Vosloo" wrote in message
...
How can I print a list of the tables in my data base?

Thanks Duane,

I didn't post this but I will add it to my FAQ database. I
am sure I will need it someday.

Jim

-----Original Message-----
You can use SQL in a query like:
SELECT msysobjects.Name, msysobjects.Type
FROM msysobjects
WHERE Type IN (1,6);
Keep in mind that this will display system tables and may
miss some ODBC
table (not sure).

--
Duane Hookom
MS Access MVP


"Benn Vosloo" wrote
in message
...
How can I print a list of the tables in my data base?


.