Unlink command

  • Thread starter Thread starter J.J.
  • Start date Start date
J

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"
 
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
 
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.
 
He has something valed ADOX methods for deleting tables. it doesn't do
anything more than a regular delete
 
Back
Top