>Maybe this will help : http://forums.asp.net/t/1378795.aspx
>Snip:
>
>HOWEVER, you cannot get table relationships with GetSchema(). Trying object types like "Relationships" or "ForeignKeys" or "Contraints" just won't work. Do not fret, though; the solution turns out to be very simple!
>Just use GetOleDbSchemaTable() instead of GetSchema(). Here's how:
>string[] restrictions = { null };
>DataTable dt = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys, restrictions);
>The most interesting columns in the resulting table are called PK_TABLE_NAME, PK_COLUMN_NAME, FK_TABLE_NAME, & FK_COLUMN_NAME.

This returned zero rows.





>
>HTH,
>Viv
>
>>I already tried. I don't see any join info in the result set.
>>
>>
>>
>>>I know nothing about Access but if you call GetSchema() without specifying a collection name you should get *everything* back.
>>>As a last resort poking around in that should give you a clue to the collection you need......
>>>
>>>>I have this code:
>>>>
>>>>

>>>>static void Main(string[] args)
>>>>{
>>>>    // Microsoft Access provider factory
>>>>    DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
>>>>
>>>>    DataTable Info = null;
>>>>
>>>>    using (DbConnection connection = factory.CreateConnection())
>>>>    {
>>>>        // c:\test\test.mdb
>>>>        connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=K:\KevinM\Apex\APEX Data Warehouse - ProfitKey San Marcos.mdb";
>>>>
>>>>        // We only want user tables, not system tables
>>>>        //string[] restrictions = new string[4];
>>>>        //restrictions[3] = "Columns";
>>>>
>>>>        connection.Open();
>>>>
>>>>        // Get list of user tables
>>>>        //Info = connection.GetSchema("Tables", restrictions);
>>>>        // Info = connection.GetSchema("Tables");
>>>>        Info = connection.GetSchema("Views");
>>>>
>>>>        int Count = Info.Rows.Count;
>>>>    }
>>>>}
>>>>

>>>>
>>>>It returns table and view info for an MS Access database. Anyone know how to get the JOIN info?