Andy,

Would the code below work in VB.Net?

set odb=oserver.databases("Northwind")

Thanks

Jim

Andy,

The program retrieves the databases and lists them in a list box. When the user clicks on a database the tables for that database...

Thanks for the feedback. I am new to the whole for each loop thing. would I use the code below?

foreach (this.poSqlDMO.Databases.ItemByID(DatabaseNumber).Tables in this.poSqlDMO.Databases)

{

this.lstTables.Items.Add (this.poSqlDMO.Databases.ItemByID(DatabaseNumber).Tables.ItemByID(i).Name);

}

Thanks

Jim