Results 1 to 3 of 3
  1. #1
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83

    Append query duplicating records

    Hi,

    I'm using Access 2016 linking to a Sharepoint 2013 online list. I import spreadsheets and run an append query to add the new items to the SP list. For some reason, for the last several weeks, it is doubling the line items that it appends.

    For example, I just imported a spreadsheet with 36 rows, ran the append query and it added 72 rows to my SP list. I've made sure there were no blank rows in my access imported table, done compact/repair, increased the time-out in properties, made sure it's connected to the SP list, etc. I have not been able to find any reason that this is happening.

    Has anyone else experienced this?



    Thanks!

    Toni

  2. #2
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    What the code / SQL behind the append?
    Can you post up some of the import sample data?

  3. #3
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83
    Hi Minty,

    No special coding, just a standard append query I built in design view. There are several more columns, but here's the basic parts.

    INSERT INTO [SAMPLES ORDER TRACKER] ( STYLE, [SIZE], QTY )
    SELECT [SAMPLES ORDER TRACKER].STYLE, [SAMPLES ORDER TRACKER].SIZE, [SAMPLES ORDER TRACKER].QTY
    FROM [SAMPLES ORDER TRACKER];

    Looking at the SQL behind makes me think that maybe I could isolate the problem by re-building and running the query a column at a time to see if I can find where it's creating the duplicate records, thoughts?

    Thank you for your help, much appreciated.

    Toni

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

Similar Threads

  1. Replies: 19
    Last Post: 10-03-2017, 09:10 AM
  2. Access can't append all the records in the append query
    By fluffyvampirekitten in forum Access
    Replies: 2
    Last Post: 08-27-2015, 01:53 AM
  3. Replies: 4
    Last Post: 07-24-2015, 07:03 AM
  4. setting up a form for duplicating records
    By phineas629 in forum Forms
    Replies: 4
    Last Post: 10-26-2011, 02:24 PM
  5. duplicating records
    By kstyles in forum Queries
    Replies: 7
    Last Post: 12-31-2010, 02:31 PM

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