Cannot Delete or Alter a table Relationship to save my life

[Shido151]

I have 2013 Access Web database that I'm trying to upload to Sharepoint. However there is a relationship between a User Table ID field and a software table Id field that is not web compatible and I cannot delete it. I have saved a copy of the DB, deleted every form, report, query, validation rule, and table I could find. (don't know how to search for hidden macros if any) yet here is this relatioship that will not go away.




I've clicked on " Home\More\SubDataSheet\SubDataSheet " and I can see the master and child field links there, but everytime I try to delete or change it, they pop right back up when I close out and reopen the tables.

I know someone out there has a quick and simple fix that I'm unaware of, please share if you know it.

[offie]

I don't have 2013 so this is a guess. Where are you deleting the relatioship? In 2010 under "Database Tools" click on "Relatioships" and edit them there. These are kind of the "master" relationships, not ones made specific to queries.

[Shido151]

Thanks for the reply but the Relationships button is greyed out. It's acting as if there is no relationships.