How do I delete a table in another database using VBA?

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I want to delete the table "OldStuff" in a different database called
"OtherDatabase".

How is that done?

Access 2000
 
Dim dbOther As DAO.Database

Set dbOther = OpenDatabase("E:\Folder\OtherDatabase.mdb")
dbOther.TableDefs.Delete "OldStuff"
dbOther.Close
Set dbOther = Nothing
 
Back
Top