Hi all.
I am developing in VS.NET C#.
I have connected to access with ODBC driver,
and want to display the list of the tables in database file (xxx.mdb).
can anyone tell me is it possible, if yes how?

thanks.

On Mon, 6 Dec 2004 18:26:15 +0400, "Hovhannes Asatryan" <hovhannes_asatryan (AT) epygilab (DOT) am> wrote:

¤ Hi all.
¤ I am developing in VS.NET C#.
¤ I have connected to access with ODBC driver,
¤ and want to display the list of the tables in database file (xxx.mdb).
¤ can anyone tell me is it possible, if yes how?

Can you use Jet OLEDB instead of ODBC? If so you can use GetOleDbSchemaTable. Otherwise, with ODBC,
you will have to query a Microsoft Access system table which I don't recommend.

The below example uses SQL Server but you can change the connection string to Access and Jet OLEDB.

How To Retrieve Schema Information by Using GetOleDbSchemaTable and Visual C# .NET
http://support.microsoft.com/default...b;en-us;309681


Paul ~~~ pclement (AT) ameritech (DOT) net
Microsoft MVP (Visual Basic)