If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Modifying table design breaks Append query
I have a table that I delete all records from/then append records to on a daily basis. I modified the table by adding another field. My Append query now rejects a little over half the records due to validation rules violations. I've set no new rules. The new field is not required and has no validation rules. When I delete the modified table and replace it with the backup (thank GOD I backed up before playing this game) the query appends all records with no errors. I played with modifying the table by deleting a field, (instead of adding a field to see if the problem was how I modified) and I recieved the same number of rejects. My query brings in several Autonumber PK's from different tables (as longs you can't have more that one Autonumber in the receiving table) I am wondering if my can-o-worms is due to the different PK's. I've also tried Compact/Repair to fix. Has anyone had problems similar to this and can you provide possible solutions please?
|
#2
|
|||
|
|||
Modifying table design breaks Append query
You may have to "walk" through your append query, deleting one field at a
time and testing to find the "offending" field. Then, back to the table definition to determine what about THAT field is leading to errors. JOPO (just one person's opinion) Jeff Boyce Access MVP |
#3
|
|||
|
|||
Modifying table design breaks Append query
FOUND IT!!! Thank you very much. One of the fields was a text field set to AllowZeroLength = No. Why this did not reject on the earlier table I do not know; but, setting AllowZeroLength = Yes (in Design view, Field Properties).
Thanks Jeff. "Jeff Boyce" wrote: You may have to "walk" through your append query, deleting one field at a time and testing to find the "offending" field. Then, back to the table definition to determine what about THAT field is leading to errors. JOPO (just one person's opinion) Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|