fin access

[anthony.carter]

Hi out there

ready to throw access into the main road!

we have an update query that adds data into an empty table from a ever
changing original table, it works beautifully first time but then
loses the plot once all the data is within the table ie it will not
run a second time, throwing up violations,

have we done something obviously wrong?

Tony

 

[Allen Browne]

What violations?

Does this help explain it?
Why can't I append some records?
at:
http://allenbrowne.com/casu-19.html

 

[anthony.carter]

Thanks

Yes it was a key violation and I get why it failed now. Couldn't think
of a straight forward solution so worked around it by setting up
another query that deleted the records. Then set up an autoexec macro
that ran the delete query and then the append/update query. Ugly but
it works!

Cheers,

TC