Share via

access 2010 append query failing "due to validation rule violations"

Anonymous
2014-10-06T13:03:45+00:00

We have two ms access 2010 tables in the same database: neither table has any keys or indexes, all fields in both tables are defined as Text, allow zero length is set to YES, there are no validation rules in either table, no auto numbers in either table, no links to any other tables, no relationships established in either table.  The destination table is empty, the source table has 3 fields, the destination table has 20 fields. We have done compact and repair multiple times. We continue to get the failure that Access cannot append 1800 records due to validation rule violations. Help would be appreciated.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2014-10-06T17:27:32+00:00

    We did not use SQL but here is the SQL view of the append query:

    INSERT INTO Patients ( INS )

    SELECT ForAccessPatientsFromLogPffice.INS

    FROM ForAccessPatientsFromLogPffice;

    What do you mean you didn't use SQL? An Append query IS a SQL statement.

    It is not a good idea to not have a PK on a table. 

    But based on the SQL statement. Since you you are adding only one field, there is something in that field that doesn't conform. What is the datatypes on both sides? can you show a screen shot of the first fe records in ForAccessPatientsFromLogPffice?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-10-06T17:19:18+00:00

    We did not use SQL but here is the SQL view of the append query:

    INSERT INTO Patients ( INS )

    SELECT ForAccessPatientsFromLogPffice.INS

    FROM ForAccessPatientsFromLogPffice;

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-10-06T17:08:38+00:00

    No. In neither table.

    Was this answer helpful?

    0 comments
  4. ScottGem 68,810 Reputation points Volunteer Moderator
    2014-10-06T14:39:28+00:00

    And can you post the SQL statement you are using?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2014-10-06T14:28:37+00:00

    Are any of the fields set as Required?

    Was this answer helpful?

    0 comments