deleting a table in an other database

R

rafik

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
 
D

Douglas J. Steele

I usually use DAO:

Dim dbOther As DAO.Database

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