Allowing user to lock out other users inside session

[hlnewman]

I've got an Access 2000 database with forms that is routinely open for multiple users to update at once (with the Edited Record being locked). But once a month, one user needs to create a report from all the other users' input, after which she presses a button to archive the data from the current table to a "past" table and wipe out the current table's data.

Needless to say, there's a real problem if people try to enter additional information while this process is underway, because the new data won't make it into the report, but will be wiped when the data is transferred.

Is there any way to give this user, who already has her own password-protected form for table activities, a way to lock other users out of the database while she is using it? I'd be all right with others always being locked out while she was using it, but it would be ideal if there were a button she could push to just lock when she really needs to.

Thanks for your thoughts.

 

[nrugado]

Add a counter to the table the houses the records. Then try adding criteria to each of the queries. Have the user that creates the report type in the max value of the counter. Add criteria to each of the queries that transfers, reports and deletes the data to only do so if the value is less than the <= the value that she determined at the time of the report, transfer and purge. Data entered as she is working this is left for the next report and is not deleted.