"you cannot record changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the min

[thenum1roc]

I am running an access append query in access 2010. And I keep getting the following error:

"you cannot record changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). correct the error and try again"


I have looked in the two tables I am importing from and to in order to determine the field data types in both; the fields were all the same so I am slightly confused.


Does anyone have suggestions based on their past experiences?


Thanks

 

[Joe4]

Are any of your field types set to allow unique entries only, and the append query would create a duplicate (which would violate that rule)?

If you cannot figure it out, I would try breaking up the records or fields so you are doing smaller "chunks" at a time, so you can try to zero in on the offending record.

 

[james_lankford]

my first thought was your table has a validation rule on the column, so open the table in design mode and check that out

but here's another possible problem
http://www.utteraccess.com/forum/Access-2007-UPgrade-Probl-t1708392.html

 

[Dan Newton]

I just ran into this problem -- I was trying to append records from a linked table into a local table.

The problem was that the linked table had been incorrectly mapped. When I opened the linked table from within Access, one column was returning an error. I needed to re-link the table correctly and then the error went away.