|
Subject:
|
Dynamically pulling table names from a database
|
|
Posted By:
|
conundrum
|
Post Date:
|
11/4/2003 4:29:31 AM
|
I want to dynamically pull in a list of tables from a database to help define dynamically generated reports. How can this be done?
|
|
Reply By:
|
sal
|
Reply Date:
|
11/5/2003 9:56:05 AM
|
Please be more specific. There is a system table is Access called MSysObjects. This will give you a list of all tables in the database.
Sal
|
|
Reply By:
|
urbanPuppy
|
Reply Date:
|
12/21/2003 6:49:01 PM
|
select * from MSysObjects
will show you all of the columns you can get which does include the Table names.
HINT : Open the Database in Access Tools > Options > View Tab. Tick System objects this will show you the table
|
