Simulatenous Access within Access

Hi Guys,

it might be a slight oversight on my part but nonetheless is crucially important, where i have multiple users accessing a temporary table and it is causing errors if a record changes.

The core of my data is stored in 5 tables. Upon a "record challenge" the data is pulled via a append query into a temporary table. This then displays the information in a "recording challenge" form. if a user is challenge a record on a single user basis, he will be able to submit the change and this is fed into the main table upon validating checks etc.

The issue occurs in multi user access where 2 users could be in the "recording challenge" form (fed from the temporary table), looking at two separate records. the data is obviously wiped from the temporary table and shows multiple #Deleted items in all the fields and displays run time error 3329. Im not sure if i can attach a screen shot to this thread somehow?

The crux of the matter is how do i go about multiple user access to the temporary table and continue concurrency.

Please may you advise urgently as I am super stuck and my googling as been unsuccessful :(

Manny