Wednesday, December 12, 2012 10:36 PM
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.
Wednesday, December 12, 2012 10:42 PM
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.
- Marked As Answer by AllTheGoodNamesWereTaken Wednesday, December 12, 2012 10:42 PM
Thursday, December 13, 2012 7:48 AMModerator