CODEWITHSUNDEEP
ms-accessappend
O.Baklanova
O.Baklanova

Reputation: 17

Access 2013 Append error

I am doing Append query in Access 2013. It says to me that I am going to append 13 number (correct quantity) of rows; however, after I click Yes I get the error "...set 0 field(s) to Null due to a type conversion failure, and ....13 records due to key violations, and...due to validation rule violations." But when I created a temporary table and tried to append to that table first, and then that temporary table append to the destination table, it worked fine. But when I did another copy of the Database, and applied all queries I used in the previous one, Append query didn't work again. I did the research and I checked primary key, foreign keys, table settings, field settings,looked everywhere, it should work fine, but it doesn't..

The error message: Error append query

The query: Append query

INSERT INTO tblMain ( DispID, StartDate, ExpDate, AgreType, 
            VersionNo, OPSYEAR, CreatedBy, CreatedOn ) 
  SELECT TempTable_Update.DispID, TempTable_Update.StartDate,
    TempTable_Update.ExpDate, TempTable_Update.AgreType, 
    TempTable_Update.VersionNo, TempTable_Update.OPSYEAR, 
    TempTable_Update.CreatedBy, TempTable_Update.CreatedOn 
  FROM TempTable_Update

Please help me to solve this issues!

Upvotes: 0

Views: 118

Answers (1)

O.Baklanova
O.Baklanova

Reputation: 17

Database was corrupted. It happened without any visible reason. So I remade the database, now it works fine. Thank you all for your help!

Upvotes: 0

Related Questions