Open and detect MS Access structure

[Maileen]

Hi,

In my application, I want to load a MS Access database, open it and get
the database structure (number of tables, name of tables and their
structure - fields).

how can i do it ?

does someone have an example for me please ?
thanks,

Maileen

 

[Cor Ligthert]

Maileen,

I thought that I had seen how this goes, however do not know it exactly
anymore.

Probably you have more change in the newsgroup

Microsoft.public.dotnet.framework.adonet

I would give it a try there when I was you.

Cor

 

[james]

There is a good example on how to do this at Planet Source Code's website:

http://www.planetsourcecode.com/

just select .NET in the upper right part of the screen then at the bottom of the new screen you will see a listing of different
subjects. Select Databases.
You will have to go thru several pages till you find an example program called: Database Explorer.(VB.NET code)
I believe that program (with code listing) will show you how to do what you want.
You will have to register (free) to download. But, it only takes a minute or so. Once you do, they will email you a password .
james