Problems with tables and updating

  • Thread starter Thread starter Kentucky5
  • Start date Start date
K

Kentucky5

I have one table that I have created a query to update. I
have made sure that all the fields from the from table and
the to table are the same format, but when I do the data
does not append to the data and I am not sure why.

Any Suggestions?
 
Are you actually running the query by hitting the ! icon? If so, what sort of error
message do you get?

Are you trying to append a primary key field with unique id values? If so, Access will
refuse to do this, saying it "didn't add n records due to key violations". You must
delete any primary key field before appending.

(I'm not an expert but have been appending a lot of data recently! Hope this helps,
anyway).

Andrew L.
 
You are not going to believe this, the one thing that was
stopping this from working is one of the fields I had to
make it allow zero length. So I have fixed that issue,
thank you for your help.

-----Original Message-----
Are you actually running the query by hitting the !
Click to expand...
icon? If so, what sort of error
 
Back
Top