We have a problem of my colleague.
We are not the creator of the ms access db. The DB works well on the previous months. Now, when the data or the date column of our database have a value "2017" . We got an error of Key Value Violation..somewhat like that. When i change one its record with the date of "2016" the date went through or appended. I serched the entire table but can't see anything. I also look for the entity relationship but cant see the diagram in case there is a criteria for year but is shows nothing
Anyone can help me or give advise?
Thanks for the help.