How to delete a table from another database

Topic

New Reply

How to delete a table from another database

I want to open a database from another database, and then delete the talble Orders in the opened database.However the code made by me doesn

Reply | Quote

Replies

Hi,
Try this:
Dim cat As New ADOX.Catalog, objConn As New ADODB.Connection
objConn.Open “Provider= Microsoft.Jet.OLEDB.4.0;Data Source = c:BEstoreBE.mdb”
with cat
.ActiveConnection = objConn
.Tables.Delete “orders”
end with
Hope that helps.

Reply | Quote