In MS Access, I am trying to change the data type of a field from number to text. However, Access says I cannot do it because there is a relationship set up. I have deleted all relationships, restarted several times and fiddled a lot, yet Access keeps saying that I have a relationship and won't let me change the data type. If anyone can help, it would be much appreciated. thanks!