hi,

i was using this code to access data from a table in oracle -

dim cn as new adodb.connection
dim rs as new adodb.recordset
dim str as string

str="select * from products"
cn.connectionstring ="dsn=aaa;uid=aaa;pwd=aaa"
cn.open
rs.open str,cn

now the problem is if that if the table doesnt exist, i get an error which is pretty much obvious. my question is how do i trap this error in VB. or may be how do i code to check whether a table exists in oracle or not. thanks