Naming a table by getting Enviroment settings

I need to be able to pull a users login and then take that login varable and use it as a table name.
The reason for this is we are on a network and are going to have a number of people accessing the same database and same tables. One of the tables needs to be updated live so the next user can have the right count. At the same time users are writting and reading from the same table. We also need to be able to delete that users information from a temp table once their order is finished. Does any one have any ideas?

Not sure that all your questions can be answered correctly because I am not sure what exactly your database structure looks like and what you are wanting to do. But to get your user login, use the function from this link http://www.mvps.org/access/api/api0008.htm

Tables are always current, which means that whenever a record is changed or added and as soon as you leave that record, those records become the current records. A open form based on a table/query will display those records prior to any changes that were made to the table. Once the records in the table are changed or added, the open form needs to be refreshed or requeried to display the current data from that table/query. You cannot have two people writing to the same table at the same time without creating errors or write conflicts and possible database corruption. So you need to design or set up your database so that only one person can change or write records at a time to a specific table. Deleting records will require compacting the database to recover the "memory" to keep the database optimized. You won't have to do this everytime you delete a few records, but something to keep in mind especially in a network environment when adding and deleting records is done frequently.

lwells