Creating A Dynamic Table Based On A Variable

[eforce]

creating and naming dynamic table based on variable

Hello All,
Was wondering if you could help me out. I need to know how I can have a table be dynamically created based on a variable like the usernID. I looked into the make table query, and went into the SQL view but couldn't figure out how to have the tables name become the user's name.

I'm already using the userID in queries and such but need to know what code could be used so that I could use this userID to name the table.

I'm using Forms!FLogin!LoginName in my queries. I've done many searches but cannot find anything on this.

The reason I need seperate created tables is because the query I'm using is a "make table". As you know, these tables are deleted and then created with the newest query data. I have up to 10 users which may want to command this operation simutaneously therefore, I need each user to have his/her own table so that there would be no chance of them simultaneously attempting to delete/create the same table.

I also want to avoid having to physically create a table for each user because I will possibly have to add users which in-turns forces me to create more tables.

Thanks,

Eforce!

 

[FoFa]

Why not setup a WORK/TEMP table that you can APPEND to and use the userid as a key so only that user deletes/appends their data to the table?

 

[eforce]

How would I set a temp table dynamically for each user?

Thanks,

Eforce!

 

[WayneRyan]

eforce,

You don't want to create a "new" table for each user. Like FoFa
said, you just need to have a field that identifies each user's
data.

You don't need the users to run MakeTable queries. They are
just reporting on the data within the db. If they are Select
queries (and just getting THEIR data) then all they really need
is to ID their records with their ID.

Wayne