Error Message When Deleting Table

[jj95]

All,

I have a table in my database that I no longer need. When I tried to delete it, I got the following pop-up error message:

You can't delete the table '<tablename>' until its relationship to other tables have been deleted.

It then offers to delete these relationships for me.

I have, to the best of my knowledge, deleted ALL the relationships in the database (via Database Tools, Relationships). I cannot for the life of me figure out where some other hidden relationship is. I know I can let Access delete the relationship for me, but I am more interested in finding out where in the world it is anyway.

Thanks!

 

[vbaInet]

Let's see your db, we will find it and tell you.

 

[jj95]

I think I figured it out, but very strange.

When I was deleting the relationships, what I opted to do was just delete all the tables in the relationships window (as opposed to all the individual relationships). Well, for some reason there were still there (and would show up if I clicked the "All Relationships" button.

On a whim, I decided to delete each relationship, while leaving the tables (now without connection) on the Relationship window. After that, I could delete that table (and others) without getting that error message.

I thought it was strange, perhaps it for reason and by design, but that is what I ended up doing.

Thanks for your help!

 

[vbaInet]

When I was deleting the relationships, what I opted to do was just delete all the tables in the relationships window (as opposed to all the individual relationships). Well, for some reason there were still there (and would show up if I clicked the "All Relationships" button.

That was certainly the culprit. Deleting a table from the Relationships window only removes that table from sight in the window but the relationships are still maintained.

I'm glad you got it figured out.