How to find if the table exist in my MDB ?

[snehakevin]

In my VB project I read data from different tables as per the user input, I decide the table name from the user input, before my select statement I should know if the table exist in my database. Can anyone get me the command for this?

Thanks

 

[zemp]

What database are you using? What tool are you using to connect to your database?

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[snehakevin]

I am using Visual Basic 6 and my database is in Access.
I need to find whether a table exist in the database

 

[zemp]

Are you connecting with DAO or ADO? If you are using ADO you can take a look at the .openschema method.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[CCLINT]

thread222-614350
thread709-501345