I'm trying to delete an access table from Excel.
When I try and delete the table using VBA this message appears:
"Cannot delete this index or table. It is either the current index or
is used in a relationship."
But there is no relationship with this table.
I can delete the table in access with no problem but I need to do it in
VBA.

I have tried to delete the tables by using these two methods.

strSQL = "DROP TABLE tblPrices;"
cnnX.Execute strSQL

vtSql = "DROP TABLE tblPrices"
cmd.CommandText = vtSql
cmd.Execute

Thanks

I want to copy a Cell with all its properties except for the links, which
are causing problems.

Where would I find more information about this?

Thanks,
Peter

Sorry, bad question.

My problem was that I was copying a Cell from another Sheet, and that Cell's
Formula referenced that Sheet without giving a Sheet name. So when I copied
it over it seemed to be referencing the current Sheet.

Peter.

"Peter Chatterton" wrote in message
...
I want to copy a Cell with all its properties except for the links, which
are causing problems.

Where would I find more information about this?

Thanks,
Peter