Tupacmoche
Registered User.
- Local time
- Yesterday, 21:58
- Joined
- Apr 28, 2008
- Messages
- 291
I have a multi user issue and can use some help. I don't believe that locking record is the answer but could be wrong. Here is the process, I run a macro that creates several temp tables that are used to create yet other temp tables until the final table that I need is made. This is where the problem takes place. Since, at least twenty (20) people could run this process at the same time the final table it is being over written when another user runs the process. How can this be prevented? I thought about concepts that are used in Web development where a user session variable is attached to give the table a unique name. So, for example given users Rob, Joe, Katie the table would be named tbl_rob, tbl_joe, tbl_katie. Since they have distinct names they can all exist at the same time without over writing one another. Any suggestions?:banghead: