Thanks for your reply jwshepherd. But I am able to create other temporary tables with the same connection variable.