deleting a table in an other database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to delete a temp table i create in the same Batabase. I m having
problem deleting a table in an other database does any body hase an exemple
how to do it
Thank you
 
I usually use DAO:

Dim dbOther As DAO.Database

Set dbOther = OpenDatabase("C:\Folder\File.mdb')
dbOther.TableDefs.Delete "NameOfTableToDelete"
Set dbOther = Nothing
 
Back
Top