Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
|
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2003, 05:29 AM
Authorized User
 
Join Date: Sep 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to conundrum Send a message via AIM to conundrum Send a message via Yahoo to conundrum
Default Dynamically pulling table names from a database

I want to dynamically pull in a list of tables from a database to help define dynamically generated reports. How can this be done?

 
Old November 5th, 2003, 10:56 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old December 21st, 2003, 07:49 PM
Registered User
 
Join Date: Dec 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling unique data from 1 table insert into anoth shawn.bordeaux Classic ASP Basics 0 November 9th, 2008 10:11 PM
Populate a List Box with Table Names & Table date hewstone999 Access VBA 1 February 27th, 2008 10:10 AM
Generating ViewState Names Dynamically rfinks VB How-To 3 July 31st, 2006 11:47 AM
Pulling records from the database debjanib ASP.NET 1.0 and 1.1 Professional 2 April 17th, 2006 09:03 AM
Pulling individual checkbox requests into database webasp1 Classic ASP Databases 0 February 16th, 2004 08:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.