Dynamic retrieval of MS-Access Tables and Relationships

Hi,

I would like to retrieve MS-Access database tables, columns and
relationships dynamically from .NET. However I could not find any
article/help material to do that. Could any one help me in this regard?

Cor
Thu Sep 01 02:11:36 CDT 2005

Saran,

I think that a lot of people will help you, however there are so many
samples for what you ask on Internet, that probably nobody understand what
you mean.

Therefore can you give a little more explanation for what you are looking?

Cor

Paul
Thu Sep 01 07:55:42 CDT 2005

On Wed, 31 Aug 2005 15:26:03 -0700, "saran" <saran@discussions.microsoft.com> wrote:

¤ Hi,
¤
¤ I would like to retrieve MS-Access database tables, columns and
¤ relationships dynamically from .NET. However I could not find any
¤ article/help material to do that. Could any one help me in this regard?

You need to use GetOleDbSchemaTable to do this. The options are defined under
System.Data.OleDb.OleDbSchemaGuid.

OleDbConnection.GetOleDbSchemaTable Method
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassgetoledbschematabletopic.asp

OleDbSchemaGuid Class
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbschemaguidclasstopic.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

saran
Thu Sep 01 11:01:04 CDT 2005

Thanks for your help Paul.

"Paul Clement" wrote:

> On Wed, 31 Aug 2005 15:26:03 -0700, "saran" <saran@discussions.microsoft.com> wrote:
>
> ¤ Hi,
> ¤
> ¤ I would like to retrieve MS-Access database tables, columns and
> ¤ relationships dynamically from .NET. However I could not find any
> ¤ article/help material to do that. Could any one help me in this regard?
>
> You need to use GetOleDbSchemaTable to do this. The options are defined under
> System.Data.OleDb.OleDbSchemaGuid.
>
> OleDbConnection.GetOleDbSchemaTable Method
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassgetoledbschematabletopic.asp
>
> OleDbSchemaGuid Class
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbschemaguidclasstopic.asp
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>

Robbe
Sat Sep 03 15:06:16 CDT 2005

The source code in this sample may also be of use to you:

http://www.eggheadcafe.com/articles/microsoftaccess_source_code_generator.asp

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp



"saran" <saran@discussions.microsoft.com> wrote in message
news:ECEAB146-2859-4FBA-8FAC-3329940F1071@microsoft.com...
> Hi,
>
> I would like to retrieve MS-Access database tables, columns and
> relationships dynamically from .NET. However I could not find any
> article/help material to do that. Could any one help me in this regard?