The Connection.Tables property returns a "a virtual collection used for managing the tables of the database". However this collection includes tables, views and materialised views. The .Connection.Tables["name"].Type property is always empty ("") so is there any way to tell if a Table is a real table or a view? tia bruce