I am trying to delete a table in a remote database and i receive the following:
Runtime error -2147467259(80004005)
Canot create this index or table.It is either the current index or is used in relationship.
I use the following code:
Dim cat As New ADOX.Catalog, objConn As New ADODB.Connection
objConn.Open "Provider= Microsoft.Jet.OLEDB.4.0;Data Source = C:estoree.mdb"
.ActiveConnection = objConn
How can i change my code so that i can delete the table?