Results 1 to 2 of 2
  1. #1
    cotri is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Jan 2010

    Append Query

    I am importing records from another Access database by linking tables and using the append query to transfer the records from one table to the next. I have about 5000 records in the original database I did not have the “Confirm action queries” setting checked so I let the query run that I thought would added 2 records (that is the number of records in the linked table) and now I have about 10,000 records with the last 5,000 being the 2 imported records over and over again. This same thing happened again and it brought me to about 20,000 records. I had to work out some other bugs so I have run the “Append Query” several time importing the same 2 records several times. I don’t know if this is causing problems. Once set up a unique record would never be imported more then once. I have since starting using the “Confirm action queries” and it tells me now how row(s) are being appended. There have been cases where only the 2 records in the linked table are added but I have made so many changes I don’t know how many records it will try to add next. The Table that the records are being imported does have a primary key and I have not defined one in the table being linked. Thanks for any help.

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Houston, Texas USA
    Sound like you append query has an improperly joined table.

    Post the SQL for your append query.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. append query for multiple databases
    By vasto in forum Access
    Replies: 0
    Last Post: 09-24-2009, 08:34 AM
  3. append query error
    By shashigk in forum Queries
    Replies: 2
    Last Post: 09-22-2009, 07:17 AM
  4. Access append query
    By antoniorossano in forum Queries
    Replies: 1
    Last Post: 08-26-2009, 01:17 PM
  5. Replies: 2
    Last Post: 05-27-2009, 08:47 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