Viewing Schema of an Access .MDB File

[Guest]

I am using VB.NET, and have experience coding to open an Access .MDB file for
retrieving/updating data. But I would like to be able to get at the schema
of the database - see the tables list, list of fields for each table, etc.
Specifically, I eventually need to see the linked tables from within an .MDB
file, and determine what is the source of the linked table (similarly to how
you can view this information from within Access when you choose
Tools->Database Utilities->Linked Table Manager).

Is there a KB article which could step me through this?

- Thanks,

JRD

 

[Richard L Rosenheim]

John,

I know you can access that information via ADO, so I see no reason that you
can't do it via ADO.Net. The information is stored in relational tables
within the Access database. These articles should help get your started:
http://msdn.microsoft.com/library/d...g/html/deovrlistingtablesinaccessdatabase.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office10052000.asp

Richard

 

[Guest]

None of this seems applicable in my VB.NET environment. Both of the
referenced articles have to do w/coding in pre-.NET, and I am having trouble
finding something that is equivalent in .NET. Are there some similar
articles for the .NET environment?

- Thanks,

JRD

 

[Dinesh]

I am using VB.NET, and have experience coding to open an Access .MDB file for
retrieving/updating data. But I would like to be able to get at the schema
of the database - see the tables list, list of fields for each table, etc.
Specifically, I eventually need to see the linked tables from within an .MDB
file, and determine what is the source of the linked table (similarly to how
you can view this information from within Access when you choose
Tools->Database Utilities->Linked Table Manager).

Is there a KB article which could step me through this?

- Thanks,

JRD

I am using VB.NET, and have experience coding to open an Access .MDB file for
retrieving/updating data. But I would like to be able to get at the schema
of the database - see the tables list, list of fields for each table, etc.
Specifically, I eventually need to see the linked tables from within an .MDB
file, and determine what is the source of the linked table (similarly to how
you can view this information from within Access when you choose
Tools->Database Utilities->Linked Table Manager).

Is there a KB article which could step me through this?

- Thanks,