Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Read Access JOIN Metadata
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01438726
Message ID:
01438749
Views:
38
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform