Exasperating, baffling behavior in A2K!

[WillWeGetOurFreedomBack]

When I try to run the query below, I get a warning that says Access
could not insert ANY of the records due to Validation rule violations.
Access gives me NO hint WHICH fields are violating the rules or WHAT
rules are being violated!

Furthermore, I re-checked EVERY field in the target table and there
ARE NO VALIDATION RULES SET on ANY field! There is no conflict
between source and target data types on any field and NON of the
target fields are set to "Required".

The source table is called "LastNSFile" and the target table is called
"tblLeads_TEMP".

Please note that this exact same query works fine with OTHER data from
other sources. I even tried deleting the "Notes" field insert and got
the same result.

Here is the Access SQL code for the insert:

INSERT INTO tblLeads_TEMP ( [First Name], State, EMail, Phone_Day,
Phone_Eve, Fax, TimeZone, User1, User2, User3, User4, Fax_Note,
CallNotes )
SELECT LastNSFile.Name, LastNSFile.State, LastNSFile.Email,
LastNSFile.Phone1, LastNSFile.Phone2, LastNSFile.Phone3,
LastNSFile.TZ, LastNSFile.DebtAmount, LastNSFile.[#Cards],
LastNSFile.[#CardsinCollection], LastNSFile.TYPE, LastNSFile.p3ext,
"Notes: " & [LastNSFile]![Notes] & ", DOR: " & [LastNSFile]![DOR] & ",
TOR: " & [LastNSFile]![TOR] & ", BTTC: " & [LastNSFile]![BTTC] AS
Expr1
FROM LastNSFile;

Does anyone have a clue why this is happening?

Thanks for all responses.

[Fletcher Arnold]

<WillWeGetOurFreedomBack> wrote in message
news:dl********************************@4ax.com...

When I try to run the query below, I get a warning that says Access
could not insert ANY of the records due to Validation rule violations.
Access gives me NO hint WHICH fields are violating the rules or WHAT
rules are being violated!

Furthermore, I re-checked EVERY field in the target table and there
ARE NO VALIDATION RULES SET on ANY field! There is no conflict
between source and target data types on any field and NON of the
target fields are set to "Required".

The source table is called "LastNSFile" and the target table is called
"tblLeads_TEMP".

Please note that this exact same query works fine with OTHER data from
other sources. I even tried deleting the "Notes" field insert and got
the same result.

Here is the Access SQL code for the insert:

INSERT INTO tblLeads_TEMP ( [First Name], State, EMail, Phone_Day,
Phone_Eve, Fax, TimeZone, User1, User2, User3, User4, Fax_Note,
CallNotes )
SELECT LastNSFile.Name, LastNSFile.State, LastNSFile.Email,
LastNSFile.Phone1, LastNSFile.Phone2, LastNSFile.Phone3,
LastNSFile.TZ, LastNSFile.DebtAmount, LastNSFile.[#Cards],
LastNSFile.[#CardsinCollection], LastNSFile.TYPE, LastNSFile.p3ext,
"Notes: " & [LastNSFile]![Notes] & ", DOR: " & [LastNSFile]![DOR] & ",
TOR: " & [LastNSFile]![TOR] & ", BTTC: " & [LastNSFile]![BTTC] AS
Expr1
FROM LastNSFile;

Does anyone have a clue why this is happening?

Thanks for all responses.

My first guess is that the problem is caused by one or more text fields in
tblLeads_TEMP not allowing zero length strings. There is a distinction
between a null value and a zero-length string (although both of them 'just
look blank' in the table).
If you do not care about this distinction, change the design to allow
zero-length strings and see if your append query now works.

PS - Don't forget to take a backup before taking advice from strangers.

Fletcher