Reading Access Structure...

[Evan Camilleri]

Is there a way (besides opening the database using Access) that I can read
the structure (not just tables, even forms etc) of a database file? I would
like to read it from a .NET project.

Evan

 

[Pieter Wijnen]

All main objects (Name & Type) can be queried using MSysObjects
Relationships using MSysRelationShips
Import/Export specs using MSysIMEXSpecs & MSysIMEXColumns
Queries definition using MSysObjects & MSysQueries

Pieter

 

[Douglas J. Steele]

Assuming you have Access on the machine, you could use Automation from .Net.

 

[Albert D. Kallal]

windows has shipped with the "JET" engine for a very long time.

So, you can write a windows script, or use .net and ado to open up a mdb
file. You don't need to install ms-access at all....

You thus read the data with great ease.

The forms? No, I don't think you can read them unless you want to decipher
them. No more so then ms-access is going to be able to open and read forms
built in .net....