I believe that this code will give you a list of tables in an Access database. I haven't been able to test it though.

Code:
SELECT Name FROM MSysObjects
WHERE Type=1 AND Flags=0
Dropping tables is simple:
Code:
DROP TABLE t_test
I got all the above information from here