Unlink command

[J.J.]

I'm wondering if anyone has any ideas?
I saw an earlier reference on how to unlink a table where the responder
replied to use the Delete command. I tried this but get an error message
"You can't delete the table; it is participating in one or more
relationships." There were no linked forms open to "myTable." I need to
unlink before I can relink or else it opens a second instance of "myTable"
I tried doing the following:
DoCmd.DeleteObject acTable, "myTable"
DoCmd.TransferDatabase acLink, "Microsoft Access",
"e:\Database\OtherSource.mdb", acTable, "myTable", "myTable"

 

[J.J.]

Duh,

I figured it out . I was thinking of something entirely else. "One or more
relationships" refers to table relationships. The child tables have to be
deleted first.

Thank you one and all just the same

 

[J.J.]

I thought I had it figured out but I am still having problemsa deleting child
tables. Is there another way to unlink or "force" the delete? I am able to
delete the link manually without problem.

Any ideas? Thank you.

 

[Jim Burke in Novi]

The relationships have to be deleted. I've never done that through VBA code
myself, but here's a link to one of Allen Brown's pages that has an example
(just do a find on relationship once you get to the page).

http://allenbrowne.com/func-ADOX.html#DeleteKeyAdox

 

[J.J.]

He has something valed ADOX methods for deleting tables. it doesn't do
anything more than a regular delete