creating tables thru forms

[cihow81]

Hi,

If i have a new entry from the user, and i want access to create a table on its own, with the table name defined by the user and the elements of the tables already pre-defined by a sample table that i already do out... Is there any way of doing it? Thanks for any helpful souls around...

 

[WayneRyan]

ci,

Why would you want a new table for every user?

You should just add a username/userid when they enter records.

That way, you can deal with them collectively (or individually)
quite easily.

If you start proliferating tables, it will increase the complexity
of doing forms/reports.

Wayne

 

[cihow81]

let me elaborate my scenerio, currently i am doing a database for product tracking. If there r new products, i want the administrator to be able to select an option in the form page for new product, and a new table will be created with that name as the table name. The reason for doing so is because, these products are due for frequent testing, and old experimental results are supposed to be kept inside the database for future reference...

With my limited knowledge or too little knowledge on access, i thought that a better way will be creating multiple tables for each individual products... so that i could store in all the historical datas, and i also can input in new experimental datas. I am sure there is better ways, could anyone kindly advise on these. Thanks.