Because some of the queries in this runtime app I develop take so long to run, I have created a couple of temporary tables to store data. A final query pulls from one of the temporary table to feed a form. For some time now the users keep getting #Deleted in textboxes. I've searched everywhere for explanation and couldn't figure out why, but I think I've concluded that it's due to the temporary table's data being deleted and appended every time that form is being executed.
So, the question is, what is the other alternative method or common practice I should be using, so that no one loses data when there are users using the same form at the same time?