Re-creating tables in Access from Excel
 

I have a reset database function in my Excel sheet that re-creates several
tables in the Access database.

I tried the DAO way (db.execute) and application way docmd to no avail.

Access complains that the tables are locked and errors out.

What is the best way to achieve create / delete tables (supressing any
waning messages) from Excel?

JB