delete table if existis ado and vb6

[sal21]

I need a code to loop in all tables of access database and delete table if existis...
Possible?

[HansV]

Are there relationships with enforced referential integrity between the tables in the database?

[sal21]

Are there relationships with enforced referential integrity between the tables in the database?

no... is sample service table

[HansV]

Do you want to delete a specific table or do you want to delete all tables?
Do you want to do this within Access or from Excel?

[sal21]

Do you want to delete a specific table or do you want to delete all tables?
Do you want to do this within Access or from Excel?

one table...
Example:

loop in all tables in mdb access anf if MyTable exists delete it.

I need in vba for excel or vb classic.
I just have active conn on access database named CN

[HansV]

Try this:

On Error Resume Next
CN.Execute "DROP TABLE MyTable"
On Error GoTo 0