Hi
I'm using access with sql server & there are approx 20-30 users accessing my db at any one time. I'm adding some quite complex reports which need to scan through the db tables & populate report specific tables on the server to act as a record source each time they are run. I'm worried about what will happen if two people run the same report within seconds of each other, especially since the report tables are truncated each time the reports are run.
This must be a fairly common problem, how is it best approached? I've thought about updating a table to show which reports are currently being run, would this be ok?
I'm using access with sql server & there are approx 20-30 users accessing my db at any one time. I'm adding some quite complex reports which need to scan through the db tables & populate report specific tables on the server to act as a record source each time they are run. I'm worried about what will happen if two people run the same report within seconds of each other, especially since the report tables are truncated each time the reports are run.
This must be a fairly common problem, how is it best approached? I've thought about updating a table to show which reports are currently being run, would this be ok?
