Thanks Sergey,
Switching to a temporary table does look to be the only solution. I may also try using a more permanent holding table for those situations where a temporary table is not possible.
Thanks again.
Ben
Ben Sugden
"Remember to enjoy hunting - and that means relishing the search for the product that has never been advertised or placed handily at the front of the shop; Life begins on the uppermost shelf, avoid guide books and top 10's like the plague." - Ramsey Dukes