Deleting an Access Table using VB.

[Gaff]

I'm trying to Delete an Access table using VB. I don't even know if this is possible. I couldn't even do it using SQl in Access. I know in Oracle there is the DROP table method and i was wondering if there is any similar method in Access, and then i could just execute it from the VB frontend. Thanks.

 

[Ed2020]

DROP is an SQL statement and is used to delete links to tables.

If you want to delete a local table (not linked) in VB then use DoCmd.DeleteObject.

Does this help?

Ed Metcalfe.

 

[Gaff]

Ya that is exactly what i wanted.Works fine. Thanks Ed