text: does any one know t about how to find table through ado in vb6?   select * from sysobjects where xtype='u'   this will give you list of all user defined objects - from which you can further filter down to tables.