creating tables in VB using Enviroment

[woods]

I am trying to create a table using their login as the table name. I have captured their login but, how and can I apply that to a table name.

 

[Mile-O]

Firstly, why would you want to create a table per user?

 

[woods]

User ID's and Table Names

We are on a network. There are going to be a number of supervisors accessing the same mdb at the same time, that will create an order. Once the order is done per user, the table that holds the counts needs to be updated live. So that the next supervisor will see the correct information, and also when that user is finished we need to delete their information from the table without deleting everyone elses.

 

[Mile-O]

Split your database so that your users have their own frontend. The backend should reside on the network.

Rather than create a table for each person, put a field into the one table that identifies them. Use a delete query to remove only their details.