Renamed a table involved in relationship, now I am messed up. How to recover?

Question

Access 2010. I am trying to get a database ready for user testing. The main table has had many changes and I need to pull in the production table and modify it so I keep the production data. So I renamed the development table to something else and imported the production table. Now I have to run some conversion routines. One of these routines failed with referential integrity constraints. It turns out the table I renamed was involved in a relationship under its old name. I need this relationship to be re-established with the table I imported and deleted from the renamed table. However, Access still thinks the old renamed table is related and this is causing the referential integrity check to fail.

How do I get around this? I went into relationships and deleted the relationship but that did not help.

Answer 1

Ok, it was pretty simple. All I had to do was to go ito Relationships and display the table under its old name, then the unwanted relationship showed up and I was able to remove it.

Personally, I think that when you rename a table and it is involved in a relationship, it would be really nice if Access asked if you wanted to keep the relationship or not.

Answer 2

Thanks for your sharing and have a nice day.

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.