What Relationships?

[Mik3]

Hi,
I need to change the Data Type of a field from AutoNumber to Number, however I'm getting an error message that the field is in one or more relationships.
The thing is that there are no relationships linked to its table. I checked the relationships windows, tried "show all", but still no relationships. Do I have to delete the relationships in the queries? However the message does no mention any queries - only to check the relationships window.

 

[AncientOne]

Try compacting & repairing the database.

 

[Mik3]

I tried that, but I still got the error msg.
However, I solved the problem otherwise.
Thanks all the same.