Results 1 to 2 of 2
  1. #1
    greatwhite is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Location
    Ottawa, ON
    Posts
    56

    Problem inserting data

    OK so my application creates a temp table that is almost the same as the regular table . I will post a picture. When I try to insert the data from the regular data to the temp data I get an error.



    I get the error regardless if I do it from the application or by SQL statement. I checked for duplicates and their are none and there are no null values in my data

    I tried to insert the data manually using this statement.

    INSERT INTO tblEquipPanelBreaker_Temp ( keyBreaker, keyEquip, numBreakerPosition, numBreakerDetailRow, strBreakerSize, optA103, keyCableDn, [Phase 1], [Phase 2] )


    SELECT keyEquipPanelBreaker, keyEquip, numBreakerPosition, numBreakerDetailRow, strBreakerSize, optA103, keyCableDn, strPhase1, strPhase2
    FROM tblEquipPanelBreaker


    Below are some pics, the first table has the data the second table is my temp table which I am trying to push the data into. Contrary to the error there were no records locked and I cannot see how there would be a key violation. Any suggestions would be appreciated.

    Click image for larger version. 

Name:	error.PNG 
Views:	8 
Size:	12.7 KB 
ID:	38060

    Click image for larger version. 

Name:	Equip.PNG 
Views:	7 
Size:	26.7 KB 
ID:	38061

    Click image for larger version. 

Name:	temp.PNG 
Views:	7 
Size:	17.1 KB 
ID:	38062

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    And the solution was???
    It may just help someone in the same situation ---and you have an answer.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. inserting pictures in form problem with code
    By Baja GEary in forum Forms
    Replies: 2
    Last Post: 02-23-2018, 01:17 PM
  2. Replies: 24
    Last Post: 06-26-2014, 11:23 AM
  3. Inserting Data
    By dandoescode in forum Programming
    Replies: 6
    Last Post: 06-07-2012, 09:17 AM
  4. Replies: 3
    Last Post: 01-06-2012, 03:30 PM
  5. !!Please Please Help!! Inserting my Data
    By dinorbaccess in forum Access
    Replies: 9
    Last Post: 01-08-2011, 05:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums