Datbase Table Listing?

Datbase Table Listing?

I am looking for a way to get a list of tables in an Access/SQL Server 
Database.  Is there a method or a code example of this somewhere.  I would 
like to create a drop down list with the table names that are located in an 
ACCESS database.  Any help would be greatly appreciated.

Thanks,

John C. Hill

date: Mon, 20 Feb 2006 09:35:03 -0600 author: John C. Hill

Re: Datbase Table Listing?

In SQL Server you can query the SYSOBJECTS table

"John C. Hill"  escribi en el mensaje 
news:O$6c7MjNGHA.3576@TK2MSFTNGP15.phx.gbl...
>I am looking for a way to get a list of tables in an Access/SQL Server 
>Database.  Is there a method or a code example of this somewhere.  I would 
>like to create a drop down list with the table names that are located in an 
>ACCESS database.  Any help would be greatly appreciated.
>
> Thanks,
>
> John C. Hill
>

date: Tue, 21 Feb 2006 12:25:48 +0100 author: RPS

Re: Datbase Table Listing?

if somebody knows any method, then please help. I tried GetOleDbSchemaTable() method, but not getting desired result

date: Thu, 23 Mar 2006 01:11:40 -0800 author: unknown