Access Table Existence

[Offsuit9_2]

Want to test for the existence of a table in an Access Database. If it's there, I want to delete it so that I can reuse it in another make table query. Any ideas? Here are the connection objects I'm using:

Public cnAWAC As New OleDb.OleDbConnection
Public cmd As New OleDb.OleDbCommand
Public rdr As OleDb.OleDbDataReader

Thanks a bundle.

 

[fpineda101]

Do a select on the table. If there are any errors then its not there. If you get something, drop it

 

[Offsuit9_2]

Thank you - that's pretty much what I wound up doing. I thought I remembered there being a table existence test, but maybe that was with a SQL database.