Deleting Tables

[Milan]

Hi People!

How can i delete a table (not just the records , but the table itself) from vba.

Is it done using the tabledef object?


Thanks Again.

 

[dcx693]

What version of Access do you use? Or more precisely, are you using DAO or ADO?

You can also do it through SQL with this:
"DROP TABLE yourtablename;"

 

[Milan]

i was planning to use DAO.!

 

[dcx693]

On Error Resume Next
CurrentDb.TableDefs.Delete "yourtablename"

The error check is just there in case you try to delete a table that doesn't actually exist. Just put this into your code and run. You might want to make the sub a bit more useful and pass the tablename as a parameter.

 

[Milan]

Thanks!! I have found the answer!! in this forum!.

Thanks for your help!!

 

[Milan]

dcx693 Thanks

i used your solution, work a treat!!

Cheers for that!