Delete a table from another database

[yippie_ky_yay]

Hello forum,

I need to be able to delete a table. It's the result of a make table query which I use for reports - but could never be uploaded on our website (presently, I open the database, delete the table and then upload it).

I was thinking that I could link the table in question from another database, and delete all the records leaving me with an empty table.

Is there not a better way though? Could I not drop the whole table without having to open the database it's housed in?

Any help/advice would be greatly appreciated!

-Sean

 

[Tim K.]

Try this code on other db.

Private Sub DeleteTable()
Dim dbs As Database
Set dbs = OpenDatabase("c:\yourtargetdb.mdb")
On Error Resume Next
dbs.TableDefs.Delete "Table1 "
dbs.Close
Set dbs = Nothing
End Sub

 

[yippie_ky_yay]

Thank you Tim - worked beautifully! Much appreciated!

-Sean