Agent collision on data import question
I'm preparing an import routine which is pretty central to the DB solution I've built. It'll be used many times by many people in a FM Server/Client environment.
The basis is that a user imports data to what's basically a temporary table, whereupon they can review the data prior to a full import to the main data table.
A script fires when the user hits 'Go' and performs the import to the main data table. The final act of the 'Go' script is to delete all records on the temp table, leaving it clear for the next import.
I need to ensure that there can be only one set of data on the temp table at any one time and that this is being used by only the user who placed it there until the 'Go' script has run its course.
I have no idea how I might do this and I hope I've made the scenario clear!
Thanks in advance