Importing Data Between Databases

I have searched and not found exactly what I am looking for..so here is my question.

I have a large database that works fine, IF people would stop trying to play in it!! What I want to do is to restrict access to everyone except managers.

So, I copied the db for warehouse users to input their data (picker id, no. of minutes) that holds only one table and the form that opens automatically (they do not have access to anything but the form) for their input...Then, at the end of shift I want the managers to be able to click a button on Switchboard that copies all entries for day into the original db to run their reports. (These dbs are on a network)

So, how do I manage this? I want to use a macro and transfer database table, then run an append query to put the current records in original table...I can do that, but I dont know how to delete the records in users db. It needs to clear out all records in that db when it has been transferred... I want all control to be in managers hands. All the users can do is input their data.

I know you can help, so I will say thank you now.