Appending Overwriting, instead of appending

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't figure this one out - an append query is overwriting the first record
in the table, instead of appending it to the end.

Please help - thank.
 
There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here.
Information on primary keys and relationships would be a nice touch too. Also
any indexes.
 
Another thought: Are you sure that it's overwriting the first record in the
table OR it's just showing up first when you open the table? What is the
primary key field for the table? That's how you can tell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
check while appending data 3
Append Query 1
Access 2010 append query to SQL is very slow 0
Schedule Auto run Query on append table 0
data append & overwrite by 1 step 4
Data changes in append query 1
Append Query is not working 1

Back
Top