If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
List of the tables
How can I print a list of the tables in my data base?
|
#2
|
|||
|
|||
List of the tables
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? |
#3
|
|||
|
|||
List of the tables
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? . |
Thread Tools | |
Display Modes | |
|
|