I am trying to find out how to test connections to databases.

How do i test if a database i am connecting to has opened correctly. Is there a property that will give me a boolean value.

Also when i run a sql statement that will populate a new table, am i able to interrogate the table with DAO to see if its been populated. Any help would be good .

Finally, is there a way of interrogating a database to see if a table exists.

I am using VB5 DAO and ACCCESS 97

M