Changing Tables within Queries (1 Viewer)

[sound_trax]

Hi

Does anyone know how I can change the table that a query looks at whilst the program is running. At the minute there are 20 posssible tables that I may want to delete a record from. I could have 20 delete queries and that would work but this mean everytime a new user joins the business I would have to create a lot of queries and tables for them. I have an invisible text box on a form and that is the name of the table I want to reference for the query.

Does anyone know how this can be done, I don't mind using VB at all.

Thanks in advance

 

[Atomic Shrimp]

It sounds like the issue might be a little deeper than just how to delete from a named table; are you saying that you have 20 different tables which all have the same structure, and all contain information of similar type (but perhaps separate because they have different owners or something?

If this is the case, you really need to store all the data in a single table; if you still need a way of splitting it up for different users/owner or something, then you just need an extra field to identify the rightful owner of each record.

[This message has been edited by Mike Gurman (edited 07-31-2001).]