I'm not sure as I'm not connected to that network from home but I think it was a syntax error that had something todo with Jet4. I fixed the problem by replacing the update query with a delete and insert but am still interested as to why it didn't work.