Append query NOT appending

  • Thread starter Thread starter Alan B. Densky
  • Start date Start date
A

Alan B. Densky

I have an Access 2000 database. I wrote an append query to append from one
table to another. The fields are all the same. The only key on the table
that I'm trying to add data to is an AutoNumber field. I am NOT trying to
append data to this field.

The problem, the query refuses to add the record(s) PERIOD. And I cannot see
any reason for this. I've done this a thousand times.

By the way, there are no security restrictions of any kind on the table or
the query.

Any ideas?

Alan D
 
Never mind. There was some kind of corruption. I deleted the autonumber
field, saved the db, then added it back and now everything works fine.

ABD
 
You must log in or register to reply here.

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
Append Queries 5
Access 2010 append query to SQL is very slow 0
Append query - Append to table with Autonumber field 2
AutoNumber Field Not Populating with Append Query 2
Choose append field based on criteria 4
Append Query is not working 1
Data changes in append query 1

Back
Top