none
Append Query not working - Type conversion failure RRS feed

  • Question

  • Hi

    Having a query like this:

    INSERT INTO [Recept humlerader] ( [Bryggning nr] )
    SELECT CLng(Val([Formulär]![KopieraReceptFångaOldAndNewReceptNr]![NewNr])) AS Uttryck1
    FROM KopieraReceptLäggTillHumleRaderETT;

    If I look att the query in "datasheet view" the Selected value is "180"

    If I run the append Query there is an error message "Microsoft Access can't append all the records in the append query.”

    And further "Key violations "

    But the Key in table "Recept humlerader" is as simple "ID" , and I just want to append "Bryggning nr" and yes duplicates is allowed.

    What can I do?


    Best // Peter Forss Stockholm and Sigtuna GMT +1.00

    Wednesday, September 14, 2016 12:49 PM

Answers

  • Hi

    Shame on me.

    It was an open Form locking the table.

    Sorry guys


    Best // Peter Forss Stockholm and Sigtuna GMT +1.00

    • Marked as answer by ForssPeterNova Wednesday, September 14, 2016 1:01 PM
    Wednesday, September 14, 2016 1:01 PM