Query Failures

[houseofturner]

I have a set of 5 or 6 queries which first purge a table of all data and then append new data from a selection of excel files which are set up as linked tables.

The odd thing is that if I run them once it works fine.

If I then run them again I get the error:

you cannot record your 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.

If I then compact and repair I can run them again.

And so it goes on....

If they run the first time and then will run again after a compact and repair then I dont understand where the error is coming from.

 

[Alansidman]

Do you have any of the fields set in the table to No Duplicates? Check the properties. This may be a confusing issue when you are importing records. Check for maximum and minimum values in the properties also.

 

[houseofturner]

There is nothing like that. What I cant understand is why it always works the first time and not the second. The first part of the process deletes all the data so running it the second time is the same as running it the first. The data hasn't changed.

 

[Alansidman]

Well I suppose if you want some real help here, you will need to post a copy of your db so that your codes can be anlayzed. Otherwise, we are just shooting blanks at a target while blindfolded.

 

[spikepl]

There is a bunch of suggestions here: http://www.utteraccess.com/forum/Access-2007-UPgrade-Probl-t1708392.html