I am using VB6 to maintain Access 2000 tables. I need to delete tables and repopulate them with data from our main. Our customer table is 25,000 records and the only way I have found to delete the table is to go through the records one by one and delete them. The delete process on this one table alone takes about 30 minutes.

Is there a way to copy the table setup (variables, relationships etc), delete the entire table and recreate it using the copy?

Thanks in advance.

Ray