Dropping/deleting linked tables in VBA or query

[dumbledown]

Hi,
I have a number of linked tables that vary depending on use.
Can anyone point me in the right direction to delete them or drop them all from the database? I produced/stole some code that deleted all tables - but it didn't delete the linked ones.
Thanks very much

[Robeen]

I've never had to do this - and I don't use linked Tables much - but see if the code on this site is any help. I have not tried it.
http://www.devhut.net/2011/06/10/ms-...linked-tables/

[dumbledown]

Thanks Robeen - that works perfectly!

[Robeen]

Happy to help!