>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; > } >} >>