fin access

  • Thread starter Thread starter anthony.carter
  • Start date Start date
A

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
 
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
 
Back
Top