Cannot append to empty table

J

Jeff Boyce

When I get a "0 records will be ..." message, there's usually an
explanation, like, "n were not updated due to key violation, ..." What does
your message say?
 
N

Newbie

Okay, I've seen a few posts about this in the past, but no one seemed to
know the deal, so I'm asking again.

In Access XP, I have 1 empty table and one chock full of data. I make a new
append query, and whether I try to append one field, 5, or all of them,
Access says 0 records will be updated (it's not an error, it's Access'
normal message, only saying that 0 records will be updated).

If I enter any piece of data in any field of the empty table (thus creating
one record), then the query works and updates all the records, and I can
delete the "dummy" record I had to create in order to get the query to work.

Does anyone know why this is?

Thanks for any help

newbie supreme
 
N

Newbie

It's the same box as the one that appears when it does work:

"Access is going to update 0 records. You can't undo this operation, do you
wish to proceed?"

Not word for word, perhaps, but it's the same box as when it actually
updates records, only it's doing it to 0 instead of the whole table. When I
enter 1 dummy record in the destination table, it then has the same box but
that 1000 records will be updated. There is no error, the query "works",
only it updates 0 records when the destination is an empty table.

Weird, isn't it?

Newbie Supreme
 
J

John W. Vinson

In Access XP, I have 1 empty table and one chock full of data. I make a new
append query, and whether I try to append one field, 5, or all of them,
Access says 0 records will be updated (it's not an error, it's Access'
normal message, only saying that 0 records will be updated).
Click to expand...

Sounds like you've created an *UPDATE* query, which alters the values
of fields in existing records, rather than an *APPEND* query which
adds new records. Could you open the query in SQL view and post it
here?
 
N

Newbie

TB said:
Do you have an append query or an Update query?
Click to expand...

It is an append query, but with an update query I didn't seem to be able to
go from one table to another; the choice of fields for the destination were
only from the table the source data was in. I had both tables in the query
design, but couldn't choose the empty one as destination for fields from
populated one. This specific problem with 0 records updated unless I enter
a dummy field is in an Append Query
 
Top