Delete Table In Another Access DB

[tubbsy123]

Hi,

I have two Access 2003 databases. The master is Export_Process.mdb and the other is DBExport.mdb.

I need to delete the table, tblCampaign, from DBExport. But the initiation must come from the database, Export_Process.mdb. The deletion will be run as part of some other code.

The location of the other database is:

M:\Tools\Databases\Export (PHG)\DBExport.mdb

I have tried various methods but can't seem to get anywhere close.

Any help would be greatly received.

Thanks

Tubbsy123

 

[PHV]

A starting point:

Set myDB = DBEngine.OpenDatabase("M:\Tools\Databases\Export (PHG)\DBExport.mdb")
myDB.TableDefs.Delete "tblCampaign"
myDB.Close
Set myDB = Nothing

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886